database questions

Discussion in 'Databases' started by rsavra, Nov 1, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. rsavra

    rsavra

    Hello group,

    how can I view the contents of tables?
    How can I browser in table's data like an normal Sql Server on my own machine?
    Where can I learn about Sql serve studio ...? does it have any user manual?

    Thanks.
     
    rsavra, Nov 1, 2010
    #1
  2. dmitri

    dmitri DiscountASP.NET Staff

    To view the content of a table, you will need to connect to your database with Management Studio. Please see this KB article for the instructions. After you connect to your database, open Object Explorer (F8) and Object Explorer Details (F7). Now you can browse your database and its objects in the same way you browse files with Windows Explorer. To view the contents of a table, right-click on it and select "Select Top 1000 Rows" from the content menu. The other way to view the content of a table is to hit "New Query" button to open a new query window and write a select statement such as:

    SELECT * FROM [YourTableName]

    To learn about Management Studio features, I recommend browsing Microsoft Books Online here .
     
    dmitri, Nov 1, 2010
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page