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?

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

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

You can use,

use databasename go select * from tablename

This might help