stored procedure

[raja]

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?

[Kenneth Wilhelmsson]

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?