标签归档:Replace

Search and Replace in a TEXT(NTEXT)

MSSQL: Search and Replace in a TEXT(NTEXT) columnIt’s been a while since I’ve posted anything SQL related. So… Sometimes we need to search and replace a text value in the entire table. The column in question is of TEXT or NTEXT datatype. T-SQL REPLACE function does not work with TEXT/NTEXT datatype. 继续阅读

T-SQL Find and Replace

SQL Server Find and Replace Values in All Tables and All Text Columns

Problem
In a previous tip, Searching and finding a string value in all columns in a SQL Server table, you showed how to find a string value in any text column in any table in a database. I was wondering how this can be taken a step further to allow a replacement of text in a string data type for all columns and tables in my database. I have read about a SQL injection attack where text is inserted and this could be a good way to remove the offending text.
继续阅读