Monday, October 5, 2009

Customize Top Select and Top Edit Rows in SQL Server 2008 Object Explorer

In SQL Server 2008 Object Explorer provides a inbuilt option to retrieve Top number of records, also There is an another provision to edit Top records.

By Default, the value will be 1000 for selection and 200 for Edit.

Have a look at the Exhibit.

Some times, if you want to select very less number of records, you need to write the query with Top Keyword.

Here is a provision to customize this value by following ways.

Go to Tools Menu Select Options… 

In Options Window, Select SQL Server Object Explorer, Commands

Here you can change the values as you likes. I changed 5 for Edit and 100 for select.

 After updated the values, it will looks like

Hope it helps you!

No comments:

Post a Comment