[thelist] MSSQL Stored Proc problem
Steve Lewis
slewis at macrovista.net
Fri Jan 3 15:53:01 CST 2003
rudy wrote:
>>How can I pass the variable-length list of question_numbers to the
>>stored proc?
> as a single varchar parameter, containing a comma-delimited list
>
> since they are float, i.e. numbers (okay, i won't ask), you don't even have
> to wrap single quotes around each list item
It barfed on that.
> have you tested the query in query analyzer or enterprise manager?
Yes, with quotes it complains about the implicit conversion from varchar
to float. Without quotes it complains about the SET (when building and
testing SPs I work in Query Analyser and just use DECLAREs and SETs to
build the environment) where we define the parameter.
--Steve
More information about the thelist
mailing list