22,209
社区成员
发帖
与我相关
我的任务
分享
--参考:
create table #t(TableName nvarchar(32),ISO_GB decimal(18,3),Check_MD5 varchar(50),ISO_Type varchar(50),Result varchar(50))
exec sp_MSforeachtable @command1="insert #t select '?',ISO_GB,Check_MD5,ISO_Type,Result from ? where PN='100000-B22'",
@whereand="and o.name like 'USB%'"
select * from #t
CREATE PROCEDURE Qeury(@PN varchar(10))
AS
SELECT ISO_GB, Check_MD5, ISO_Type, Result
FROM (
SELECT * FROM usb1th WHERE PN=@PN
UNION ALL
SELECT * FROM usb2th WHERE PN=@PN
UNION ALL
/*...*/
SELECT * FROM usb45th WHERE PN=@PN
) t
GO