Hai guys, I installed sql server 2008 and i cant view table data .. When i rightclick on the table it shows select top 1000 rows,edit top 200 rows... How to view all the rows of my table...
A:
I'm assuming you are trying to view all the records in a table and there are more than 1000? In that case
SELECT * FROM <table name here>
or select the "select top 1000 rows" option and then just remove the "TOP 1000" from the query
monkey_p
2009-12-24 08:26:17
thats fair enough... Sql erver 2005 has an option of ViewTable and that option is not there in sql server 2008
Pandiya Chendur
2009-12-24 08:35:41
Then select the edit top 200 rows option and press "Ctrl+3" to display the query and remove the "TOP (200)" from the query and press "Ctrl+r" to re run the query
monkey_p
2009-12-24 09:03:58
this will give you the same output as SQL 2005, they just limited the amount of data return by default in SQL 2008
monkey_p
2009-12-24 09:04:57