不使用游标删除用户表中有ProjectID的内容

declare @s varchar(8000)
declare @strProjectID VARCHAR(100)
set @s=”
SET @strProjectID=’ND0702′
select @s=@s+’Delete from ‘+o.name + ‘ where ProjectID=”’ + @strProjectID +””+ char(10) from sysobjects o
inner join syscolumns c on c.name=’ProjectID’ and   o.id=c.id
where o.xtype=’u’
–print @s
exec(@s)

收藏本文到网摘: 百度搜藏 QQ书签 Google书签 Del.icio.us 新浪ViVi 雅虎收藏 饭否 365Key网摘 天极网摘 POCO网摘 和讯网摘

Random Posts

Leave a Reply