不使用游标删除用户表中有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)










