22,210
社区成员
发帖
与我相关
我的任务
分享
DECLARE @s VARCHAR(1000)
SET @s=''
SELECT @s=@s+'select * from '+t.NAME+' where SN=100 '
FROM sys.COLUMNS c
INNER JOIN sys.tables t
ON t.[object_id]=c.[object_id]
WHERE t.is_ms_shipped=0
AND c.name='SN'
EXEC (@s)
DECLARE @s VARCHAR(1000)
SET @s=''
SELECT @s=@s+'select * from '+t.NAME+' where id=100 '
FROM sys.COLUMNS c
INNER JOIN sys.tables t
ON t.[object_id]=c.[object_id]
WHERE t.is_ms_shipped=0
AND c.name='id'
EXEC (@s)
select
a.name,b.*
from
sys.objects a inner join sys.sql_modules b
on
a.object_id=b.object_id
where
b.[definition] like '%ABC%'