SSMS Tips and Tricks - Part 4

You tube Answer:

Q1. How to get column list with comma separation (Replace Select * with column list)

Go to Object Explorer --> Expand the database --> expand tables --> right click on the table --> Select "Script Table as" --> Select to --> New Query Editor window --> now you can copy the columns with comma separation

Q2. How to add Line numbers in SSMS

Press Ctrl + G

Or

Tool --> Options --> Text Editor --> All Languages --> check the check box --> Line Numbers

Q3. How to Wrap text in SSMS

Tool --> Options --> Text Editor --> All Languages --> check the check box -->  Word wrap