Uer defined function return value
-
I am trying to return a text string from a user defined function that returns a value of varchar(8000). However the function truncates the string if it is longer than around 3870 characters. How can I return more characters than this from a user defined function. The string is an SQL statement put together by other user defined functions based on the input parameters and existing data. Any help would be appreciated. Cheers in advance
-
This is the only other way (other than running direct batch queries) to get around the 4000 character limit for passing csv as parameter (for selecting records in bulk).
Madhu
http://www.awprofessional.com/articles/article.asp?p=102307&seqNum=16
-
Recently there was a discussion on a similar / related problem here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=122554#bm124279
/rockmoose
You must unlearn what You have learnt -
Thanks for the advice. I have split the function into 4 each returning a smaller SQL string which is concatenated before being run by EXEC.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply