Saturday, March 5, 2016

SSMS Tips and Tricks

Type All Column Names Quickly

Instead of typing all column names manually for a table, you can drag them quickly from the Object Explorer.

 

 

 

Use Go Command to Execute Statement Multiple Times

 

If you enter a number after the GO command, then the statement or batch preceding is executed that many times. This can be useful for creating test data, among other things.

 

 

 

No comments:

Post a Comment