创建存储过程

use TESTgocreate PROCEDURE [dbo].[SP_物料出入库周期](    @起始日期 VARCHAR(8),    @结束日期 VARCHAR(8)    @id char(3) output) ASBEGIN    SET NOCOUNT ON;             --当 SET NOCOUNT 为 ON 时，不返回计数。当 SET NOCOUNT 为 OFF 时，返回计数。----------------删除临时表--------------------------------------if object_id('tempdb..#TempA') is not null drop table #TempA; --------------------------------------------------------------select  INVMC.MC001 as '品号' ,MB002 as '品名',INVMC.MC002 as '仓库' ,CMSMC.MC002 as '仓库名称',INVMC.MC007 as '库存数量' ,INVMC.MC011 as '上次盘点日' ,INVMC.MC012 as '最近入库日' ,INVMC.MC013 as '最近出库日'  from INVMC ,INVMB ,CMSMC where     INVMC.MC001 = MB001 and INVMC.MC002 = CMSMC.MC001    and ((INVMC.MC012 BETWEEN @起始日期 AND @结束日期 ) or (INVMC.MC013 BETWEEN @起始日期 AND @结束日期 ))    and INVMC.MC002 in ('101','102','103','104','106','110')---------------------------------------------------------------End---------------------------------------------------------------declare @id char(3)exec TEST..SP_ASCII 90,90,57,@d = @id outputselect @id as 序号