How can I change the Select Top <N> Rows command in SQL SMS 2008

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.
Sam EdwardsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rbeadieCommented:
Try using row_number instead of TOP:

SELECT * FROM
(
select *, row_number() over( order by MyID) MyRowNumber
from MyTable
) T1
WHERE T1.MyRowNumber <= 1000
0
Sam EdwardsonAuthor Commented:
thanks for the reply rbeadie but I obviously didnt make my self clear.  The function comes from right clicking on the table and it automatically writes the query for you.  I want to edit this automated query so that it still pulls all the columns into the query but does not display them like this:
/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [JobID]
      ,[MarketID]
      ,[CountryCode]
      ,[AccountNumber]
      ,[IssueNumber]
      ,[Status]
      ,[KeyRef]
      ,[Reference]
      ,[Position]
      ,[Skills]
      ,[Location]
      ,[StartDate]
      ,[Duration]
      ,[Contact]
      ,[Telephone]
      ,[Fax]
      ,[Email]
      ,[KeyLocations]
      ,[JobType]
      ,[Rate]
      ,[DatePosted]
      ,[URL]
      ,[JBEIssueNumber]
  FROM [Jobs].[dbo].[tJob]

I want the query to output like this:
SELECT TOP 1000 * FROM [Jobs].[dbo].[tJob]
0
rbeadieCommented:
Ah -- sorry.  I understand your question now.  I'm not sure that you can change that functionality.  You can change the number of rows that is your default, but there are limited changes you can make to the ssms generated scripts.
0
SharathData EngineerCommented:
You cannot change that. Thats a functionality provided to get the top 1000 records.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sam EdwardsonAuthor Commented:
Guess I'll just have to put up with it then :-)  Thanks for the replies
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.