In this post we will lean how to run a stored procedure from a batch file (.bat) externally. This is used very often to run a schedule job set in the server. The whole job logic is written in the Stored procedure and we are executing that from an external batch file. So what we have to do to run this, lets see.
We will use the sqlcmd.exe file to run the stored procedure from command. First...
Monday, June 20, 2016
Subscribe to:
Posts (Atom)