CODEWITHSUNDEEP
sql-server-2008
ACP
ACP

Reputation: 35268

View data of a table in sql server 2008

I installed sql server 2008 and I can't 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?

Upvotes: 5

Views: 92952

Answers (3)

shadab shah
shadab shah

Reputation: 561

You can use,

use databasename go select * from tablename

This might help

Upvotes: 0

Kobie
Kobie

Reputation: 31

Try this, On the menu Select Tools-> Options->SQL Server Object Explorer->Commands Under Table and View Options you can alter the default value for "Value for Edit Rows command, and Value for Select Top Rows command

Upvotes: 3

monkey_p
monkey_p

Reputation: 2879

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

Upvotes: 8

Related Questions