Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Exploring SSMS - Changing Top N rows values

Jul 11 2011 2:24AM by Madhivanan   

As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to change the value of the option SELECT Top N rows

Sometimes you may need to view some sample rows from a table. In SSMS there is an option to do this. Expand to the table level.

Databases-->Your_db-->Tables. Now right click on the table and choose the option Select Top 1000 rows which will show the first 1000 rows in a new query window.

If you want to change this value, say from 1000 to 50, you can do the following

In the toolbar

Tools-->Options-->SQL Server Object Explorer. On the right side of the window change 1000 to 50 in the first row which is labelled as Value for Select top Audit records command

Other posts that come under Exploring SSMS
Enabling Save Changes
Enable/Disable intelliSense

Tags: t-sql, sql_server, sqlserver, tsql, BRH, #SQLServer, SSMS, #BI,

2 · 40% · 13039


Your Comment

Sign Up or Login to post a comment.

"Exploring SSMS - Changing Top N rows values" rated 5 out of 5 by 2 readers
Exploring SSMS - Changing Top N rows values , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]