SQL Server Management studio offers simple snippets which helps to create objects of the Database with ease without bothering much about the syntax of each object.
Snippets can be included in the query window either by browsing through
Edit->IntelliSense->InsertSnippet... or (Keyboard shortcut Ctrl K+X)
(or)
Edit->IntelliSense->SurroundWith..or (Keyboard shortcut Ctrl K+S)
Please have a look at the picture below for details of the above mentioned keyboard shortcuts.
 |
Above picture shows the Begin End, If and While block Construct which you can include anywhere in the query window just by hitting the keyboard shortcut of Ctrl K+S.
Above picture shows the object creation template(table in the above case). By clicking on any of the listed object, respective construct will be shown for the user to edit.
No comments:
Post a Comment