Friday, October 17, 2008

SQL 2008 Select All Rows

If you want to select all rows from a table using SQL Server 2008 Management Studio, here is how:
1. Go to Tools > Options > SQL Server Object Explorer
2. Change both the 'Value for Edit Top n Rows command' and 'Value for Select Top n Rows command' to zero.

3. You can now view or edit all rows of a table.

SQL 2008 - Change ‘Edit Top 200 Rows"
blog comments powered by Disqus