SQL Server Sproc Windows BAT

Howes-IT-Going SQL Server Sproc Windows BAT

The following example shows how to create your own simple SQL to execute a Sproc from a SQL Server Database via a Windows BAT file. You will need to have SQL Server 2005 or newer, Windows with admin permissions, And a text editor like: Notepad, TextPad or Wordpad. Use the SQLServer_via_Windows_BAT.txt file contents to create the needed SQL and BAT files for this example. Always make Backup copies of database tables before editing! Use this SQL At Your Own Risk!

SQLServer_via_Windows_BAT.txt Create a valid input1.sql file in same directory/folder...

Change: server_name, userid, password to actual SQL Server Database credentials..

Save As SQLServer_via_Windows_BAT.bat

Go Back to:

This Webpage and Contents Created by Steven C. Howes Howes-IT-Going 2005-2014 All rights reserved.