current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

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

1 Answer 1

up vote 1 down vote

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.