Viewing 3 posts - 1 through 3 (of 3 total)
PATINDEX will return the position of the XML in the row, and if your table contains millions of rows than it will take some time until you get the count.
Full-text...
March 16, 2004 at 8:03 am
Cross,
There is a TEXTSIZE property, which by default is 64KB (i.e. 64,000). Check it on both databases via I belive SELECT @@TEXTSIZE and the way to set it is by...
March 15, 2004 at 7:36 pm
Kari,
As you said that the datatype is blob you will have to use the WRITETEXT FUNCTION to set the column values to NULL (which is a non-logging operation) via a...
March 13, 2004 at 7:23 am
Viewing 3 posts - 1 through 3 (of 3 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy