1. Open a .sln at startup To do this, you just need to pass the full path of the .ssmssln file as an argument to the ssms.exe, eg.:
"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" "F:\SQL Server Management Studio\Projects\MySoln\MySoln.ssmssln"
2. To quickly populate a query with all the column names of a table
Just drag the ‘Columns’ word in the Object Explorer to the SQLQuery.sql et voila!
Leave a Reply