SQL Server Select Database

SQL server select database in two ways, by using SQL server Management Studio or by writing script.

Select Database SQL server Management Studio.



1)Go to SQL server management studio, select database

2)Right click on the database, click on "New Query".

3)You database is selected and you can write query on the database.

Select Database using script

You can select database by writing script also. click on "New Query"  window  and  write the following  script
 

use Database_Name

your database will be selected.

You can select multiple database in separate window.The window you will select , the database will be selected automatically