DECLARE @TableName varchar(255);
DECLARE Table_Cursor CURSOR FOR SELECT [name] FROM sysobjects WHERE xtype='U';
OPEN Table_Cursor;
FETCH NEXT FROM Table_Cursor INTO @TableName;
WHILE(@@FETCH_STATUS=0)
BEGIN
EXEC('update ['+@TableName+'] set [ftjzmj]='''' where ftjzmj =88888888 ;');
EXEC('update ['+@TableName+'] set [SYQQSSJ]= NULL where SYQQSSJ =''2999-12-31 00:00:00.000'' ;');
FETCH NEXT FROM Table_Cursor INTO @TableName;
END
CLOSE Table_Cursor;
DEALLOCATE Table_Cursor;
GO
将日期型字段赋值为空,必须为null
单引号前需要加单引号进行转义