Monday, 13 August 2012

USE Clause Example


Example: 

Using USE  clause in SQL Server , database can be changed to point to the required database instead of default database.

Change the database from default database to EXAMPLE database

Query:

 USE EXAMPLE

Before running the USE EXAMPLE command database was pointing to 'master' database.





After running the USE EXAMPLE command database was pointing to EXAMPLE database.




No comments:

Post a Comment