For MS SQL Server, I wrote a SQL script to create a database called Test and then use it right away. When I execute the script, it is showing the following error message.
Msg 911, Level 16, State 1, Server MyComputer\SQLEXPRESS, Line 3 Database 'Test' does not exist. Make sure that the name is entered correctly.
Here is my script.
USE master; CREATE DATABASE Test; USE Test;
The solution is to put a
GO statement after the
GO will signal the end of the batch of Transact-SQL statements.
Here is how I rewrite my SQL statements.
USE master; CREATE DATABASE Test; GO USE Test;