MSSQL Interview Questions and Answers
Question: How to set the current database in MS SQL Server?Answer: Once you are connected to the SQL Server, you should select a database to work with and set it as the current database using the "USE" statement with this syntax:USE database_name The following tutorial example shows you how to set "YourDataBaseName" as the current database, and create a table in "YourDataBaseName": USE YourDataBaseName GO Changed database context to 'YourDataBaseName'. CREATE TABLE Links (Name NVARCHAR(32)) GO SELECT name, type_desc, create_date FROM sys.tables GO name type_desc create_date Links USER_TABLE 2007-05-19 23:05:43.700 |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft SQL Server?
- What is the simplest way to create a new database in MS SQL Server?
- How to delete a database in MS SQL Server?
- How to download and install Microsoft .NET Framework Version 2.0?
- How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?