I have the following requirements for a stored procedure: It must call a pre-existing stored procedure and pass it a ntext or image object. I have tried the following:
Dynamic SQL on a temp table (can't add the text to the string)
TEXTPTR (can't convert byte[] back to string)
Calling Stored Procedure with datarow as parameters (syntax error)
Is there no way to accomplish this seemingly simple feat?
Many thanks,
f.
Dynamic SQL on a temp table (can't add the text to the string)
TEXTPTR (can't convert byte[] back to string)
Calling Stored Procedure with datarow as parameters (syntax error)
Is there no way to accomplish this seemingly simple feat?
Many thanks,
f.