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 |
|
new2sql2006
Starting Member
2 Posts |
 Posted - 2006-12-14 : 20:12:45
|
| My table has got 67K records but the tool is showing just 100 records other records are getting truncated. Now what i have to do in SQL statement to view the other records starting from 100 to 1000? |
|
|
new2sql2006
Starting Member
2 Posts |
Posted - 2006-12-14 : 20:18:22
|
| I sorted that outThanks all |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-12-14 : 20:20:34
|
what tool are you using to view query results? is there a "TOP 100" clause in your query? if so remove it.if you use Query Analyzer or SSMS you can view all the results easily.
www.elsasoft.org |
|
|
|
|
|
|
How to view truncated records