n00b SQL Server 2008 question!

[Darren S]

How do you view the next 200 records within SQL Server Management Studio? It seems MSoft has limited it to that in order to stop the firehose mode of earlier editions - which is fair enough.

But I'm a SQL novice and a little bit stuck - lol!

D.

 

[bigmouk]

Just open up a new query mate ...

USE [Database_Name]

SELECT *
FROM tblTable_Name

 

[Darren S]

Cheers Moz!

I noticed that there's a 'Select top 1000 rows' too.

D.

 

[ChrisR]

lol I was having a play the other day and was thinking wtf.

Thing that confused me was the edit top 200 rows, I wanted to get more out lol.

All I had to do was get the sql pane up and just remove the bit that limits it.