-
stored procedure
hai friends,
i want to execute a sql statement from stored procedure at back end.
i am getting the sql statement from front end,but i am unable to execute the sql statement from
stored procedure if it is > 255 characters. we cannot pass text type datatypes as arguments.
has anyone overcome this problem?
-
stored procedure (reply)
It's a bit fiddly, but you must parse the statement sent to the proc and store each part in a variable after n characters and the you can execute it in the proc with EXEC( @string1 + @string2 + @string3 )
Each @stringx variable can be a varchar(255) and you can have as many you want up to the point when your concatenated EXEC string reaches 255 chars.
/Kenneth
------------
raja at 3/12/99 9:56:15 AM
hai friends,
i want to execute a sql statement from stored procedure at back end.
i am getting the sql statement from front end,but i am unable to execute the sql statement from
stored procedure if it is > 255 characters. we cannot pass text type datatypes as arguments.
has anyone overcome this problem?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|