April 17, 2003 at 2:42 am
Hi all,
I'm NOT thinking of Stored Procedure with parameters. Im Thinking of runnig sql script which is saved in *.sql file
Is it possible to run sql script from a file with parameters? For example:
[pseudocode]
EXECUTE C:\SomeScriptFile.sql Parameter1, Parameter2
If 'yes', how to declare parameters in SomeScriptFile.sql
thanks
With regards
Maciej Szymañski
April 17, 2003 at 10:59 am
You can't do this AFAIK. This really is looking for stored procedures. Alteratively you could probably script something that could take the parameters and submit some dynamic sql.
Steve Jones
April 17, 2003 at 11:38 am
Agreed. You could load it up and execute it, but assuming you have to know in advance what the params are - and what to pass in - why not either put the code in your app or in a stored proc?
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply