ต้องการ UPDATE ทุกฟิลล์ ทุกตาราง ที่มีอักขระเหมือนอักขระที่ใส่ลงไปครับ

USE sexDB
GO
GO
GO

/*Always GO GO*/

DECLARE @iKey INT
DECLARE @cTableName VARCHAR(212)
DECLARE @cColumnName VARCHAR(224)
DECLARE @TableVar69 TABLE (
	                   iKey INT,
	                   Table_Name VARCHAR(212),
	                   Schema_Name VARCHAR(224),
	                   Column_Name VARCHAR(236)
	                   )

INSERT INTO @TableVar69 
SELECT ROW_NUMBER() OVER (ORDER BY a.NAME), a.NAME AS Table_Name, SCHEMA_NAME(schema_id) AS Schema_Name, b.NAME AS Column_Name
FROM sys.tables AS a
INNER JOIN sys.columns AS b ON a.OBJECT_ID = b.OBJECT_ID
WHERE b.NAME = 'JimColumnName'
ORDER BY Table_Name

WHILE EXISTS(SELECT 'ไม่เคยรักอะไรมากไปกว่าจิ๋ม' FROM @TableVar69)
BEGIN
	SELECT TOP 1 @iKey = iKey, @cTableName = Table_Name, @cColumnName = Column_Name FROM @TableVar69 
	EXECUTE('UPDATE ' + @Tablename + ' SET ' + @ColumnName + ' = ' + 'aaa7787')  /* Processing*/
	DELETE FROM @TableVar69 WHERE iKey = @iKey
END

SET strSQL = CONCAT('UPDATE TableName ', ' SET JimColumnName = ', 'aaa7787')
PREPARE stmt FROM @strSQL ;
EXECUTE stmt ;
DEALLOCATE PREPARE stmt ;

USE [sexDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[ReplaceValue_InTables]
	@pColumnName AS VARCHAR(224),
        @pSValue AS VARCHAR(236),
        @pDValue AS VARCHAR(248)
AS
BEGIN

DECLARE @iKey INT
DECLARE @cTableName VARCHAR(212)

DECLARE @TableVar69 TABLE (
	                   iKey INT,
	                   Table_Name VARCHAR(224),
	                   Schema_Name VARCHAR(236)
	                   )

INSERT INTO @TableVar69 
SELECT ROW_NUMBER() OVER (ORDER BY a.NAME), a.NAME AS Table_Name, SCHEMA_NAME(schema_id) AS Schema_Name
FROM sys.tables AS a
INNER JOIN sys.columns AS b ON a.OBJECT_ID = b.OBJECT_ID
WHERE b.NAME = @pColumnName 
ORDER BY Table_Name

WHILE EXISTS(SELECT 'ไม่เคยรักอะไรมากไปกว่าจิ๋ม' FROM @TableVar69)
BEGIN
	SELECT TOP 1 @iKey = iKey, @cTableName = Table_Name FROM @TableVar69 
	EXECUTE('UPDATE ' + @Tablename + ' SET ' + @pColumnName + ' = ' + @pDValue + ' WHERE ' + @pColumnName + ' = ' + @pSValue)  /* Processing*/
	DELETE FROM @TableVar69 WHERE iKey = @iKey
END /* End While*/

END /* End As*/

GO