Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smitha
Posting Yak Master
100 Posts |
 Posted - 2010-02-22 : 02:01:41
|
| Hi,How to view all the data in tables of sql 2008, since the viewing of table data is limited to 1000 rows only.Smitha |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 02:50:36
|
| " viewing of table data is limited to 1000 rows only"Only in the SSMS Table Viewer thingie.SELECT * FROM MyTablewill return all rows |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-22 : 03:53:48
|
quote:
Originally posted by smitha
Hi,How to view all the data in tables of sql 2008, since the viewing of table data is limited to 1000 rows only.Smitha
You should always use Query analyser for all your DML operationsMadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 03:57:42
|
| Actually SSMS does that - you right click the table and choose "View top 1000 records" and what you get is a query window with the SELECT TOP 1000 Col1, Col2, ... FROM MyTable syntax - which is also executed.So easy to remove the "TOP 1000" if you really do want all rows ... |
|
|
|
smitha
Posting Yak Master
100 Posts |
Posted - 2010-02-22 : 05:59:28
|
THANKS I GOT THE RESULTquote:
Originally posted by Kristen
Actually SSMS does that - you right click the table and choose "View top 1000 records" and what you get is a query window with the SELECT TOP 1000 Col1, Col2, ... FROM MyTable syntax - which is also executed.So easy to remove the "TOP 1000" if you really do want all rows ...
Smitha |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-02-22 : 06:31:32
|
| If you want to make the change permanently the GoTo Tools>Options>SQL Server Object Explorer and set all the values to 0.If you do so then all the rows will be returned.PBUH |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-22 : 07:26:17
|
| But I wonder why do you want to view using GUI? There is a change the data can be edited by mistake. As I told you in my first reply, use Query analyserMadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 09:01:00
|
| " If you want to make the change permanently the GoTo Tools>Options>SQL Server Object Explorer and set all the values to 0.If you do so then all the rows will be returned"Not sure that is a good answer either ... might accidentlaly do SELECT * opn a massive table!Why didn't MS built in a proper paging system for viewing the data?Even the freebie "Toad" for Oracle has that!! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-22 : 09:04:13
|
<<Why didn't MS built in a proper paging system for viewing the data?>>That sounds good. But I beleive it is a job for a reporting tool  MadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 09:10:36
|
| True. But for DBA / DEV it can be useful to just have a look at the data ... I suppose "First 1000 rows" ought to be enough to get a feel for the data - I am not going to page through a billion-row table!! |
|
|
|
|
|
|
VIEWING ALL DATA IN TABLES