dos batch sql update statements

[qweasdzxcqweasdzxc]

can someone please give me an idea as to how I should approach this? I just want to create a batch file that will run a set of sql statements. do i need to include authentication in the script? What syntax should I use for the script, etc?

 

[mrdenny]

Yes you need to enclude authentication in the script. Each command you want to run will need it's own osql command.

From a command prompt run "osql /?" with out the quotes to see all the valid paramaters.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com