22,209
社区成员
发帖
与我相关
我的任务
分享
exec sp_msforeachtable @Command1='
IF COL_LENGTH( ''?'' , ''CommunityID'') IS NOT NULL
BEGIN
DELETE FROM ? WHERE CommunityID = ''ae6d9aeb-bb92-410c-b9d2-a0b514b96da5''
END
ELSE
BEGIN
PRINT N''?''+''不存在''
END'
exec sp_msforeachtable '
declare @tsql nvarchar(1000)
IF COL_LENGTH(''?'' , ''CommunityID'') IS NOT NULL
BEGIN
select @tsql=N''delete from ''+''?''+N'' where CommunityID=''''ae6d9aeb-bb92-410c-b9d2-a0b514b96da5'''' ''
exec(@tsql)
END
ELSE
BEGIN
PRINT N''?''+''不存在''
END'