How can I change the Select Top <N> Rows command in SQL SMS 2008
Posted on 2010-03-25
How can I change the Select Top <N> Rows command in SQL SMS 2008. I know that I can change the amount or rows that it returns under tools - options - SQL Server Object Explorer, but what I would like to do is instead of it running the script and putting in all the column names, just simply put a * in instead. Like this:
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 * FROM etc etc
This way I dont get a whole list of column names running down my page. All and any help is as always much appreciated.