22,207
社区成员
发帖
与我相关
我的任务
分享
EXEC sys.sp_MSforeachtable @command1 = N'delete ? where uid=''xxx'';',
@whereand = N' and exists(select 1 from sys.columns where object_id=o.id and name=''uid'')'
DECLARE @Sql NVARCHAR(max)=''
SELECT @Sql=@Sql+'DELETE '+QUOTENAME(A.name)+' WHERE UID=''XXXX'';' FROM sys.tables AS a INNER JOIN sys.columns AS b ON a.object_id=b.object_id AND b.name='UID'
EXEC(@Sql)
XXX为条件