faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

1 of 3 people (33%) answered Yes
Recently 1 of 3 people (33%) answered Yes

Entry

Database: Microsoft SQL server: SQL: Database: Table: Operation: View: How select tables, using SQL?

Dec 22nd, 2003 13:25
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 22 December 2003 - 10:22 pm -------------------
Database: Microsoft SQL server: SQL: Database: Table: Operation: View: 
How select tables, using SQL?
---
Steps: Overview:
 1. -Open your database
 2. -Type the following SQL query:
      SELECT * FROM Person;
     ---
     Or more in general:
      SELECT * FROM <your tablename>
     ---
 3. That will show something similar to the following:
     +-----------------------+
     |NAME          PERSONKEY|
     |-----------------------|
     |John Doe      1        |
     |                       |
     |Vanessa Beau  2        |
     +-----------------------+
---
---
Internet: see also:
---
Database: Microsoft SQL server: SQL: Operation: Overview:Can you give 
an overview of SQL operations?
http://www.faqts.com/knowledge_base/view.phtml/aid/27560/fid/147
----------------------------------------------------------------------