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?

29 of 41 people (71%) answered Yes
Recently 9 of 10 people (90%) 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
----------------------------------------------------------------------