How to create a SQL database and use it in same script?

Question

This is my script:

CREATE DATABASE mydbname;
USE mydbname;

If I run 1st line, then 2nd line, it works OK.

If I run both together then I get this error:

Msg 911, Level 16, State 1, Line 3
Database 'mydbname' does not exist. Make sure that the name is entered correctly.

What is the correct way to write this script?

diiN__________ · Accepted Answer · 2021-04-09 07:40:46Z

2

Use GO inbetween:

CREATE DATABASE mydbname;
GO
USE mydbname;

answered Apr 9, 2021 at 7:40

diiN__________

7,7197 gold badges49 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1