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

----------------------------------------------------------------------