创建一个如下所示的存储过程，并将表名、主键列名和copy to列名传递给它。它将创建查询并执行。

CREATE PROCEDURE [dbo].[UpdateColumnValue]
    @tableName as varchar(100),
    @copyFromColumnName as varchar(100),
    @copyToColumnName as varchar(100)
AS
BEGIN

    DECLARE @query as varchar(max);

    SET @query = ' UPDATE ' + @tableName + 
                 ' SET ' + @copyToColumnName + ' = ' + @copyFromColumnName +
                 ' WHERE ' + @copyToColumnName + ' IS NULL';

    EXECUTE(@query);

END

您可以添加 Foreign Key 对同一表格的引用：

CREATE TABLE  DEPT (
ID INT Primary Key,
Name VARCHAR(50),
age INT ,
IID INT FOREIGN KEY REFERENCES DEPT(ID))

通过使用 UPDATE 声明：

UPDATE DEPT
SET IID=ID
WHERE IID IS NULL