How to provide input parameter for SQL script?

Question

Based on this link http://msdn.microsoft.com/en-us/library/ms170572.aspx, I successfully execute the SQL that I coded in the SQL file via the following code:

sqlcmd -S myServer\instanceName -i C:\myScript.sql

Now instead of executing a SELECT operation, I would like to have UPDATE operation. I'm wondering how to modify the above code so that it accept parameter and this parameter will be used in myScript.sql?

My sample UPDATE operation will be expected to be something like below:

UPDATE someColumn FROM someTable where tableID = @tableID;

So from the command, I will provide a tableID

Silx · Accepted Answer · 2014-04-10 07:27:17Z

1

There are few methods. Some of them are described here:

http://technet.microsoft.com/en-us/library/ms188714.aspx

sqlcmd -S myServer\instanceName -v tableID ="your_val" -i C:\myScript.sql


UPDATE someColumn FROM someTable where tableID = $(tableID);

answered Apr 10, 2014 at 7:27

Silx

2,71121 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sefa · Accepted Answer · 2014-04-10 07:28:17Z

0

With -v parameter

  -v @tableID = 1

answered Apr 10, 2014 at 7:28

Sefa

9,05210 gold badges54 silver badges85 bronze badges

Collectives™ on Stack Overflow

How to provide input parameter for SQL script?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related