Execute Stored Procedure Via Batch File

acidburn85 · #1 (**permalink**) 01-20-12, 09:10

I have a stored procedure that generates some data and dumps it into a table. I need to export data using bcp based on the data that this procedure creates. So I know how to use bcp but don't know how to execute the procedure and pass it the two variables that it needs. I googled it and sqlcmd looks promising but can get the syntax right.

The two variables are the current year and school number ie. 1112, 0021

Any thoughts?

MCrowley · #2 (**permalink**) 01-20-12, 10:25

What is the syntax you are using right now, and what is wrong with it (error messages)?

acidburn85 · #3 (**permalink**) 01-20-12, 10:32

Opps forgot to post that.

Code:

sqlcmd -S 172.16.1.5\GSchool -u oncourse -p oncourse  "exec uSP_Load_StuHalfYear '1112','0021'"

MCrowley · #4 (**permalink**) 01-20-12, 11:22

Try this:

Code:

sqlcmd -S 172.16.1.5\GSchool -u oncourse -p oncourse /Q"exec uSP_Load_StuHalfYear '1112','0021'"

Looks like you were only missing the /Q.

Internet Services

Web Development

Digital Marketing

Consumer Tech