Passing variables between batch file and .sql file for mssql server

Question

I am attempting to create a batch file in windows that will take a user's input, and pass that along to a sql file containing the following query, so that I can set a siteid, like in the following sql query:

exec sp_addlinkedserver [sqlserver1]
select * from [sqlserver1].onesource.dbo.admsites where siteid = '123'

I want to then take the results of this query, particularly the admsiteid, and then use the results of the query, and insert that into the originatorid (using another .sql file:

Use Onesource
update OSCsettings set originatorid = 'whatever-the-admsiteid-is'

How would I go about passing along these variables?

I'm not sure about SQL injection vulnerabilities in this scenario. msdn.microsoft.com/en-us/library/ms161953(v=sql.105).aspx — Sam
– Sam, Commented Jun 11, 2013 at 15:55
Is the syntax '[sqlserver1]' the correct way to reference a var arg? — djangofan
– djangofan, Commented Jun 11, 2013 at 16:32
Sam, nice link for the .bat file stuff. You should have made it an answer. — granadaCoder
– granadaCoder, Commented Jun 11, 2013 at 16:46

granadaCoder · Accepted Answer · 2013-06-11 16:28:06Z

1

sqlcmd with the -v command line

-v var = "value"

You can specify multiple variables in the list.

See:

http://msdn.microsoft.com/en-us/library/ms162773.aspx

and

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

answered Jun 11, 2013 at 16:28

granadaCoder

28.2k11 gold badges124 silver badges166 bronze badges

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

Collectives™ on Stack Overflow

Passing variables between batch file and .sql file for mssql server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related