yuanweisen

 

在存储过程中用表变量

declare @Table table (Region varchar(20),Ctry varchar(20),[BP Code] varchar(20),[BP Name] varchar(20),[Product Group] varchar(20),
[Order Load] varchar(20),[Sell In] varchar(20),[BackLog] varchar(20),[Open Inventory(Dec.08)] varchar(20),[Close Inventory(Dec.12)] varchar(20),
[ST Weekly Current] varchar(20),[ST Weekly Average] varchar(20),WOS varchar(20))
insert into @Table

posted on 2009-01-05 12:36    阅读(251)  评论(0编辑  收藏  举报

导航