tag:blogger.com,1999:blog-5849265.post8786307850928132540..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: SQLCMD -- Part IX (Batch files)Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5849265.post-33044012585490657262008-01-29T18:45:00.000+05:302008-01-29T18:45:00.000+05:30HiI have a stored proc - sql 2005. I want to call ...Hi<BR/>I have a stored proc - sql 2005. I want to call the stored proc in a batch file. Please help with the syntax for the batch file.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1215626495024622632008-01-28T11:23:00.000+05:302008-01-28T11:23:00.000+05:30Isn't there a way to invoke the SQLCMD just once.....Isn't there a way to invoke the SQLCMD just once..<BR/><BR/>SQLCMD [connect options] motherscript.sql<BR/><BR/>where motherscript.sql will have<BR/>@child1SQL<BR/>@child2SQL<BR/>----<BR/><BR/><BR/>- DebAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-89387579460993026012008-01-12T12:39:00.000+05:302008-01-12T12:39:00.000+05:30Very helpful post - nice and straightforward. Do ...Very helpful post - nice and straightforward. Do you have any tricks on how to make this work using a UNC path on a network? I am thinkng of mapping a drive in a setup scripts or something like that.Anonymousnoreply@blogger.com