Entry

Database: Microsoft SQL server: SQL: Query analyzer: How query table in a given database, using SQL?

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

----------------------------------------------------------------------
--- Knud van Eeden --- 22 December 2003 - 10:28 pm -------------------

Database: Microsoft SQL server: SQL: Query analyzer: How query table 
in a given database, using SQL?

---

Steps: Overview:

 1. -Start Microsoft SQL server Query Analyzer

 2. -A dialog box 'Connect to SQL Server' will
     open

 3. -Choose the SQL server (e.g. (local)) in the
     combobox

 4. -enable radio button 'Windows authentication'
     (or similarly -enable radio button
      'SQL Server authentication', and supply then
      your login name and password)

 5. -click button 'OK'

 6. -select from menu list the database of your choice
     (you see default 'master' in the menu taskbar.
      Choose e.g. 'Northwind' from that list)

 7. -you can then type your SQL query text in the
     'Query' dialog box:

     e.g.

      SELECT * FROM yourtablename

 8. -to run this query, click on the '>' symbol
     on the menu taskbar, or press <F5>

---
---

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

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