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?

4 of 4 people (100%) answered Yes
Recently 4 of 4 people (100%) answered Yes

Entry

Database: Microsoft SQL server: Table: SQL: How query via Microsoft SQL Server Enterprise Manager?

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


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

Database: Microsoft SQL server: Table: SQL: How query via Microsoft 
SQL Server Enterprise Manager?

---

Steps: Overview:

 1. -Open Microsoft SQL server 'Enterprise Manager'

 2. -Expand 'Microsoft SQL Servers' in the left pane
     (by clicking on the '+')

 3. -Expand 'SQL Server Group' in the left pane
     (by clicking on the '+')

 4. -Expand the server of your choice
     (e.g. your (local) (Windows NT) server
     (by clicking on the '+')

 5. -Expand 'Databases' (click on the '+')

 6. -Expand the database which you want to query
    (e.g. click on the '+' of 'mydatabase')

 7. -Double click on 'Tables' in the list

 8. -Right click on the table
     (e.g. 'mytable') of your choice

 9. -select from list 'Open table >'

10. -select from list 'Query'

11. -This will open a dialog window in which you can
     type your queries

---
---

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

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