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?

2 of 4 people (50%) answered Yes
Recently 2 of 4 people (50%) answered Yes

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
----------------------------------------------------------------------