View table data in SQL Server 2008

Question

I installed sql server 2008 and I cannot view the table data. When I click on the table, it displays a list of 1000 lines, editing 200 lines. How to view all rows of a table?

Answer 1

I assume that you are trying to view all the records in a table, and there are more than 1000 of them? In this case

SELECT * FROM <table name here>

or select the "select top 1000 rows" option and then simply remove the "TOP 1000" from the query

Answer 2

, " - > " " > " SQL Server " > " " " " " " " " "

Answer 3

you can use

use databasename go select * from tablename

This can help