SQL Server: Running Multiple Select Queries in same .SQL file

Question

I've been a long time Oracle user and generally if I needed to run multiple SQL queries, I would end one with a semicolon (;) and then start the new one. Example:

Select * from dual;
Select * myTable;

Questions:

How can I go about running the whole script in SQL Server?
How can I replicate the behavior where if I put the cursor on the second SQL statement and press F9 (or F5 in SQL Server) that only the second statement runs? In other words, if I put my cursor anywhere in the current SQL statement and press the Execute button, it will run everything after the previous semicolon (;)?

Thank you.

You can run multiple queries in SQL Server by separating them with a colon. Try doing this in SQL Server Management Studio. — Gordon Linoff
– Gordon Linoff, Commented Nov 2, 2014 at 17:15
For question 2, you probably can't. Highlighting the sql block and pressing F5 might be as good as it gets. — Dan Bracuk
– Dan Bracuk, Commented Nov 2, 2014 at 17:31

Andrei Hirsu · Accepted Answer · 2014-11-02 17:30:56Z

4

Sql Server is very permisive and you just need to write the statements in the text editor window and hit run to execut everything, you don't need anything explicit to separate them. That's if you use Management Studio. In Management Studio you can also separate batches using the GO keyword.
If you want to run a specific statement in the text editor window you just need to highlight the statements you want to run and then hit run with them highlighted and Management Studio will execute only the selected statement.

answered Nov 2, 2014 at 17:30

Andrei Hirsu

6964 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

SQL Server: Running Multiple Select Queries in same .SQL file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related