Running Multiple SQL queries

Question

I have a set of queries(more than 200)(in a notepad file) that i run every week in a sequence one by one. Can someone suggest what can i do to run them with one command. SSIS packages? Sql procedure?

I am a beginner. I am using SQL Server 2005

Stored procedure or just a .sql script would be fine "start myQueries.sql" ... or exec...i dont remember — Scotch, Aug 09 '13 at 01:39
How do you run them now? Why do you run the one-by-one and not all together? — Steve Smith, Feb 10 '21 at 13:58

score 2 · Answer 1 · edited May 23 '17 at 12:05

2

Have a look at the following: How do you import a large MS SQL .sql file?

For example:

sqlcmd -S <server> -i C:\<your file here>.sql -o

edited May 23 '17 at 12:05

Community

1
1

answered Aug 09 '13 at 01:42

Menelaos

23,508
18
90
155

score 1 · Answer 2 · answered Aug 09 '13 at 01:50

If the queries are the same week in and week out, put them in a stored procedure, and schedule them with a SQL Server Agent job.

CREATE PROCEDURE dbo.WeeklyQueries
AS
BEGIN
  SET NOCOUNT ON;

  -- 200+ queries go here
END
GO

If you're feeling ambitious, separate them by function and turn them into several stored procedures.

Once you have the procedure(s), create a job with a Transact-SQL step that points to the procedure(s) in the right database(s), and either schedule it to run weekly or just run it on demand every week.

Running Multiple SQL queries

2 Answers2