Vous ne pouvez pas remplir de formulaires sur le site de support pour le moment, pour des raisons de maintenance. Si vous avez besoin d’aide immédiatement, veuillez contacter le support technique. Veuillez nous excuser pour la gêne occasionnée.
ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in designed to speed up coding. It completes SQL statements automatically, fills in SQL fragments, generates outlines for the SQL script structure and speeds up coding with T-SQL code snippets.
ApexSQL Complete supports inserting ready-made static T-SQL code snippets into SQL scripts, and the primary purpose of the Snippets feature is to make reusing as easy as possible and therefore avoid wasting time on repetitive coding and inadvertent errors. The feature inserts predefined SQL fragments and replaces variables with context specific values to generate SQL at run-time.
ApexSQL Complete is configured with a set of predefined T-SQL code snippets, covering the most popular SQL constructs, which are listed in the Snippets manager. The manager also includes a code preview for each selected snippet:
In order to use ApexSQL Complete’s snippets, all that needs to be done is to type a snippet’s name in the query editor:
and then press Ctrl+Enter. This action will then immediately deploy a predefined code:
Also, there is an option to choose to create custom T-SQL code snippets or to simply change the already existing ones in the Create new snippet and Edit snippet windows. Both of these windows contain a list of available macros which can be used in snippets. For instance, in order to create a snippet that will later be used to deploy a predefined code for a function, inserting %DATE% macro in the code body will later return the current date. Likewise, inserting %SERVER% macro will return the connection server name, %LOGIN% will show a connection login, %DB% will return a connection database, and so on. Each macro will be automatically replaced with a context specific value:
During routine edit operations, ApexSQL Complete can save frequently used SQL code structures as snippets, and insert context-specific values as needed. By utilizing these templates, it can significantly speed up SQL coding process and avoid typing errors.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Contenu recommandé
Produit(s) :
ApexSQL Complete
Sujet(s) :
How To
Historique de l’article :
Créé le : 6/19/2019 Dernière mise à jour le : 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bienvenue dans le support
Vous trouverez le support en ligne correspondant à Quest *produit* sur les sites d’assistance affiliés. Cliquez sur Continuer pour être dirigé vers l’assistance et le contenu correspondant à *produit*.
Les versions 8, 9, et 10 d’Internet Explorer ne sont plus prises en charge.
Le portail Quest Software ne prend plus en charge Internet Explorer 8, 9 et 10. Il est recommandé de mettre à niveau votre navigateur vers la version la plus récente d’Internet Explorer ou de Chrome.
Mise à niveau vers Internet Explorer 11 Cliquez ici
Si vous continuez à utiliser Internet Explorer 8, 9 ou 10, vous ne serez pas en mesure d’exploiter pleinement les excellentes fonctionnalités en libre-service que nous proposons.