22,210
社区成员
发帖
与我相关
我的任务
分享
DECLARE @str NVARCHAR(MAX)
SET @str=''
SELECT @str =@str+ ' union all select * from ' + RTRIM(name)
FROM sysobjects
WHERE xtype = 'U'
AND name LIKE 'A20%'
SET @str = STUFF(@str, 1, 10, '')
EXEC(@str)
DECLARE @str NVARCHAR(MAX) = '';
SELECT @str += ' union all select * from ' + RTRIM(name)
FROM sys.tables
WHERE type = 'U'
AND name LIKE 'A20%';
SET @str = STUFF(@str, 1, 10, '');
EXEC(@str);