2019-03-28 SQL Server Table
-- table 是实际表 view是虚表。你可以认为view是一个查询的结果 -- 声明@tbBonds table declare @tbBonds table(TrustBondId int not null,shortName nvarchar(500),ClassName nvarchar(20),CouponBasis decimal(8,2)) -- 这里涉及到pivot行转列的知识,可参考上一篇文章 select * from ( select TrustBondId,ItemCode,ItemValue from DealStructure.TrustManagement.TrustBond where TrustId=@TrustID )p pivot (max(ItemValue) for ItemCode in (ShortName,ClassName,CouponBasis)) t -- table 表可以和其它表关联 join @tbBonds b on bps.TrustBondId=b.TrustBondId where