T sql execute sql script from a file

Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. If these are scripts you run fairly often you might consider dropping them in a stored proc and running them that way You can use osql or better yet the newer sqlcmd almost interchangeably. I am using osql in this example only because I happened to have a code sample sitting around but in production I am using sqlcmd.

Here is a snipped of code out of a larger procedure I use to run update scripts against databases. They are ordered by major, minor, release, build as I name my scripts using that convention to track releases. You are obviously missing all of my error handing, the parts where I pull available scripts from the database, setup variables, etc but you may still find this snippet useful.

The main part I like about using osql or sqlcmd is that you can run this code in ssms, or in a stored procedure called on a scheduled basis maybe or from a batch file. Very flexible. The simplest way would be to make your scripts stored procedures, and to call via the EXECUTE command each procedure in turn from a central procedure.

This is ideal if you're going to run the exact same script s over and over again or the same script with different parameters passed in. If your scripts are. You would have to know and script the exact file path and name. This cannot be done from within a stored procedure. Assuming you want to keep the 10 scripts in their own individual files, I would say the easiest way to do what you want would be to create a batch file that executes osql.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 10 years, 10 months ago. Active 1 year, 11 months ago. Viewed 85k times. To delete a single file, we specify the file name and path in the below T-SQL.

We can delete all files in a specified folder as well using the sys. In this article, we explored the new stored procedure to copy and delete the files in the SQL Server It is useful and straightforward to use. USE master ;. EXEC master. Author Recent Posts. Rajendra Gupta. As an MCSA certified and Microsoft Certified Trainer in Gurgaon, India, with 13 years of experience, Rajendra works for a variety of large companies focusing on performance optimization, monitoring, high availability, and disaster recovery strategies and implementation.

He is the creator of one of the biggest free online collections of articles on a single topic, with his part series on SQL Server Always On Availability Groups.

Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra. Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.

If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid. Related Questions. Execute the sql server script using nonexecutequery.

Execute text file in sql server.