I want to pass a command line values into an osql run stored procedure.
The commandline values should be are the values to put into the insert stored procedure that writes them to a table.
Is it possible to do this.if ur parameter is positioned 2nd then add this code in your command file.
<varname> is some variable name that you want to use to trap the parameter. lets say empid for instance
SET empid=%2
after this, the place where u wud be calling ur stored procedure use this syntax.
osql -S servername -l 60 -n -E -d dbname
-Q"EXEC sp123 @.Var1 = '%empid%'"
没有评论:
发表评论