主题：sql表变量的加载

CREATE PROCEDURE Hrdtest01
As
declare @Temp table(BillNo   nvarchar(20),
                              ProductNo  nvarchar(20),
                              ProductName  nvarchar(100),
                              Specification  nvarchar(100))

set nocount on

Insert Into @Temp(BillNo,ProductNo,ProductName,Specification)
       Select BillNo,ProductNo,ProductName,Specification from ERun_8..PD_Product
       Where ProductNo Like '374%'

set nocount off

Select BillNo as 单据编号,ProductNo as 料号,ProductName as 品名,Specification as 规格
from @Temp Order by ProductNo
Go