SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Trigger to replace strings in the Text field.

By mchern,

I was looking over internet trying to find a SP or UDF
to replace string accourences in the Text fields, I didn't
find any so I created ths trigger, may be it will be usefull as example. Be aware on the big documents it can be time consuming.
All it does is replacing < and > substrings of the encoded exml document when it is inserted to the database to theĀ  characters.

If somebody have better solution for this please let me know.

Total article views: 498 | Views in the last 30 days: 2