温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

创建存储过程

发布时间:2020-07-14 03:51:17 来源:网络 阅读:2575 作者:1097981 栏目:关系型数据库
use TEST
go
create PROCEDURE [dbo].[SP_物料出入库周期]
(
    @起始日期 VARCHAR(8),
    @结束日期 VARCHAR(8)
    @id char(3) output
) 
AS
BEGIN
    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 output
select @id as 序号
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI