本文介绍了一个SQL查询脚本，用于检查数据库中指定日期前的数据字段是否存在，并打印相关信息。
declare @sql nvarchar(max)
set @sql=''
select @sql=@sql+'if exists(select '+c.name+' from '+o.name+' where '''+c.name+'''>''2013-03-01'') print '''+o.name+'***'+QUOTENAME(c.name)+'''' from syscolumns c
inner join systypes t on c.xtype= t.xtype
inner join sysobjects o on c.id= o.id
where o.xtype='u' and t.name='datetime'
order by o.name, c.name,t.name
exec(@sql)
set @sql=''
select @sql=@sql+'if exists(select '+c.name+' from '+o.name+' where '''+c.name+'''>''2013-03-01'') print '''+o.name+'***'+QUOTENAME(c.name)+'''' from syscolumns c
inner join systypes t on c.xtype= t.xtype
inner join sysobjects o on c.id= o.id
where o.xtype='u' and t.name='datetime'
order by o.name, c.name,t.name
exec(@sql)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
