Showing posts with label Sql Server 2008. Show all posts
Showing posts with label Sql Server 2008. Show all posts

Tuesday, May 18, 2010

How to change top(n) rows command in sql server 2008

By default SQL allows editing of only 200 records at a time. In case you want to we edit more than 200 rows you can edit the setting for the count of rows to be edited. Here are the steps to make this change.

Goto Tools -->Options

In the commands tab,