Delete malicious scripts in the text field of the MSSQL database

Example of how to delete text field replacement in the MSSQL database-full table replacement. After reading a question, I sorted out a long time ago for your reference.

Example of how to delete text field replacement in the MSSQL database-full table replacement. After reading a question, I sorted out a long time ago for your reference.

The method is simple: Replace cannot be used for text fields, so patindex is used.
The Code is as follows:
-Select * from Product where P_Intro like '%