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?

28 of 40 people (70%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

Database: Microsoft SQL server: SQL: Database: Operation: Select: How to select database, using SQL?

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


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

Database: Microsoft SQL server: SQL: Database: Operation: Select: How 
to select database, using SQL?

---

For example, select a database named 'test'

Steps: Overview:

 1. -Open Microsoft SQL server Query Analyzer

 2. -Type the following command:

      USE Test

     ---

     or thus in general

      USE <your databasename>

 3. That will select that database
    (after which you can do further actions
     (like creating or selecting tables in
      this database)).

---
---

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

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