批量修改表中字段的值

最新推荐文章于 2022-03-28 10:50:42 发布

weixin_30782293

最新推荐文章于 2022-03-28 10:50:42 发布

阅读量113

点赞数

原文链接：http://www.cnblogs.com/camellibby/archive/2010/06/24/1764278.html

版权

DECLARE @tableName varchar(50),@tableCount int,@index int
SET @index=1
set @tableCount = (SELECT count(*) FROM sys.objects WHERE type = 'u')
WHILE @index<=@tableCount
begin
SELECT TOP (@index) @tableName = name FROM sys.objects WHERE type = 'u'
IF exists (SELECT * FROM sys.columns WHERE name='Createdate' and OBJECT_ID=object_id(@tableName))
begin
EXEC('update '+@tableName+' set CreateDate = getdate()')
PRINT @tableName
end
SET @index=@index+1
END

转载于:https://www.cnblogs.com/camellibby/archive/2010/06/24/1764278.html