From the SQL Server documentation :
"The input parameters and the type returned from a SVF can be any of the scalar data types supported by SQL Server, exceptrowversion,text,ntext,image,timestamp,table, orcursor"
This is a problem for me. Here's what I'm trying to do :
I have an NTEXT field in one of my tables. I want to run regular expressions on this field, and return the results from a stored procedure. Since SQL Server doesn't provide facilities to perform regular expressions, I need to use an SQLCLR function. I would have no problem doing this if my field was nvarchar. However, this field needs to be variable in length - I cannot set an upper bound. This is why I'm using NTEXT and not nvarchar in the first place.
Is there a solution to this problem? I can't imagine that I'm the only person who wants to pass strings of arbitrary size to an SQLCLR function.
The sql server 2005 nvarchar(max) is the same as sql server 2000 nText
http://msdn2.microsoft.com/en-us/library/ms178158.aspx
|||Cool. Thanks for the tip. I'll give this a shot and report back.
No comments:
Post a Comment