yuejie.sql

最新推荐文章于 2021-03-09 19:59:33 发布
最新推荐文章于 2021-03-09 19:59:33 发布
阅读量989 收藏
点赞数
CC 4.0 BY-SA版权
文章标签： join date go object table 存储
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/xluke2/article/details/301422
博客展示了多个SQL存储过程，包括sp_testyuejie、sp_stockSFC等，通过对不同表进行连接（JOIN）操作，依据日期条件筛选数据，计算各部分数量的总和，并进行加减运算得出最终结果，还涉及临时表的创建与使用。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

CREATE PROCEDURE sp_testyuejie
@date1 datetime,
@date2 datetime
 AS
SELECT isnull(tmp1.sumquantity,0) - isnull(tmp2.sumquantity,0) - isnull(tmp3.sumquantity,0) + isnull(tmp4.sumquantity,0) AS Expr1,TMP1.PARTNAME
FROM (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
        FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
              dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
        WHERE (b.BILLDATE BETWEEN @date1 and @date2)
        GROUP BY a.PARTID, a.PARTNAME) tmp1 left outer JOIN
          (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
         FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
               dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
         WHERE  (b.BILLDATE BETWEEN @date1 and @date2)
         GROUP BY a.PARTID, a.PARTNAME) tmp2 ON tmp1.PARTID = tmp2.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='1'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN @date1 and @date2
         GROUP BY a.partid
) tmp3 ON tmp1.PARTID = tmp3.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='2'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN @date1 and @date2
         GROUP BY a.partid
) tmp4 ON tmp1.PARTID = tmp4.PARTID

GO

SELECT isnull(tmp1.sumquantity,0) - isnull(tmp2.sumquantity,0) - isnull(tmp3.sumquantity,0) + isnull(tmp4.sumquantity,0) AS Expr1,TMP1.PARTNAME
FROM (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
        FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
              dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
        WHERE (b.BILLDATE BETWEEN '2005-02-01' AND '2005-02-26')
        GROUP BY a.PARTID, a.PARTNAME) tmp1 left outer JOIN
          (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
         FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
               dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
         WHERE  (b.BILLDATE BETWEEN '2005-02-01' AND '2005-02-26')
         GROUP BY a.PARTID, a.PARTNAME) tmp2 ON tmp1.PARTID = tmp2.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='1'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN '2005-02-01' AND '2005-02-26'
         GROUP BY a.partid
) tmp3 ON tmp1.PARTID = tmp3.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='2'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN '2005-02-01' AND '2005-02-26'
         GROUP BY a.partid
) tmp4 ON tmp1.PARTID = tmp4.PARTID


GO

CREATE PROCEDURE sp_stockSFC
 @Bgntime datetime,
 @Endtime datetime

AS
SELECT TOP 100 PERCENT texjc.id, texin.price, texjc.SORTTYPE, texjc.ownerid,
      texin.depotcode, ISNULL(texout.领用实际, 0) AS 领用实际, ISNULL(texout.领用票据, 0)
      AS 领用票据, ISNULL(texin.入库实际, 0) AS 入库实际, ISNULL(texin2.入库票据, 0)
      AS 入库票据, texjc.结存数量, ISNULL(texrt.入库退货票据, 0) AS 入库退货票据,
      ISNULL(texrt.入库退货实际, 0) AS 入库退货实际, ISNULL(texlt.领用退货实际, 0)
      AS 领用退货实际, ISNULL(texlt2.领用退货票据, 0) AS 领用退货票据,
      ISNULL(texin2.入库票据, 0) - ISNULL(texout.领用票据, 0) - ISNULL(texrt.入库退货票据,
      0) + ISNULL(texlt2.领用退货票据, 0) AS 当前结存票据, ISNULL(texin.入库实际, 0)
      - ISNULL(texout.领用实际, 0) - ISNULL(texrt.入库退货实际, 0)
      + ISNULL(texlt.领用退货实际, 0) AS 当前结存实际, 0 AS 期初票据, 0 AS 期初实际
FROM (


SELECT SUM(BILLQUANTITY) AS 结存票据, SUM(STOCKSUM) AS 结存金额,
              SUM(STOCKQUANTITY) AS 结存数量, SORTTYPE, ownerid, code, name, id,
              stockprice
        FROM PARTINFO
        GROUP BY SORTTYPE, ownerid, code, name, id, stockprice


)
      texjc LEFT OUTER JOIN
          (


SELECT isnull(SUM(a.quantity), 0) AS 领用退货实际,
               isnull(SUM(a.totalsum), 0) AS 领用退货金额,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='2'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN '2005-02-01' AND '2005-02-28'
         GROUP BY a.partid


) texlt ON
      texjc.id = texlt.partid LEFT OUTER JOIN
          (


SELECT isnull(SUM(a.quantity), 0) AS 领用退货票据,
               isnull(SUM(a.totalsum), 0) AS 领用退货金额,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='2'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN '2005-02-01' AND '2005-02-28'
         GROUP BY a.partid

) texlt2 ON
      texjc.id = texlt2.partid LEFT OUTER JOIN
          (

 

SELECT isnull(SUM(a.quantity), 0) AS 入库退货票据,
               isnull(SUM(a.outputqry), 0) AS 入库退货实际,
               isnull(SUM(a.totalsum), 0) AS 入库退货金额,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
        b.reimbursetype='1'AND
               b.billdate BETWEEN '2005-02-01' AND '2005-02-28'
         GROUP BY a.partid

 

) texrt ON
      texjc.id = texrt.partid LEFT OUTER JOIN
          (
SELECT isnull(SUM(a.outputqry), 0) AS 领用实际,
               isnull(SUM(a.quantity), 0) AS 领用票据,
               isnull(SUM(a.totalsum), 0) AS 领用金额,
               b.depotcode, a.partid
         FROM partsoutputbody a, partsoutputhand b
         WHERE b.billcode = b.billcode AND b.billdate BETWEEN'2005-02-01' AND '2005-02-28'
         GROUP BY b.depotcode, a.partid

 

) texout ON texjc.id = texout.partid LEFT OUTER JOIN
          (


SELECT isnull(SUM(a.quantity), 0) AS 入库实际,
               isnull(SUM(a.totalsum), 0) AS 入库金额,
               b.depotcode, a.partid,a.price
         FROM partsinputbody a, partsinputhand b
         WHERE a.billcode = b.billcode AND
               b.isexecute = 1 AND
               b.billdate BETWEEN '2005-02-01' AND '2005-02-28'
         GROUP BY b.depotcode,a.partid, a.price

 

) texin ON
      texjc.id = texin.partid LEFT OUTER JOIN
          (

 

SELECT isnull(SUM(a.quantity), 0) AS 入库票据,
               isnull(SUM(a.totalsum), 0) AS 入库金额,
               b.depotcode, a.partid
         FROM partsinputbody a, partsinputhand b
         WHERE a.billcode = b.billcode AND
               b.billdate BETWEEN '2005-02-01' AND '2005-02-28'
         GROUP BY b.depotcode, a.partid

 

) texin2 ON texjc.id = texin2.partid


GO

 

 

 

实际,消耗,期初 ,name

select a.expr1,b.expr1,b.expr1+a.expr1,b.partname
from
(SELECT isnull(tmp1.sumquantity,0) - isnull(tmp2.sumquantity,0) - isnull(tmp3.sumquantity,0) + isnull(tmp4.sumquantity,0) AS Expr1,TMP1.PARTNAME,tmp1.partid
FROM (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
        FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
              dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
        WHERE (b.BILLDATE BETWEEN '2005-02-25' AND '2005-02-26')
        GROUP BY a.PARTID, a.PARTNAME) tmp1 left outer JOIN
          (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
         FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
               dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
         WHERE  (b.BILLDATE BETWEEN '2005-02-25' AND '2005-02-26')
         GROUP BY a.PARTID, a.PARTNAME) tmp2 ON tmp1.PARTID = tmp2.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='1'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN '2005-02-25' AND '2005-02-26'
         GROUP BY a.partid
) tmp3 ON tmp1.PARTID = tmp3.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='2'AND
               b.isexecute = 1 AND
               b.billdate BETWEEN '2005-02-25' AND '2005-02-26'
         GROUP BY a.partid
) tmp4 ON tmp1.PARTID = tmp4.PARTID) a

right outer join
(
SELECT isnull(tmp1.sumquantity,0) - isnull(tmp2.sumquantity,0) - isnull(tmp3.sumquantity,0) + isnull(tmp4.sumquantity,0) AS Expr1,TMP1.PARTNAME,tmp1.partid
FROM (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
        FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
              dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
        WHERE (b.BILLDATE <= '2005-02-28')
        GROUP BY a.PARTID, a.PARTNAME) tmp1 left outer JOIN
          (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
         FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
               dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
         WHERE  (b.BILLDATE <= '2005-02-28')
         GROUP BY a.PARTID, a.PARTNAME) tmp2 ON tmp1.PARTID = tmp2.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='1'AND
               b.isexecute = 1 AND
               b.billdate <= '2005-02-28'
         GROUP BY a.partid
) tmp3 ON tmp1.PARTID = tmp3.PARTID LEFT OUTER JOIN
          (SELECT isnull(SUM(a.quantity), 0) AS sumquantity,
               a.partid
         FROM reimbursebillbody a , reimbursebillhand b
         WHERE a.billcode = b.billcode AND
               b.reimbursetype='2'AND
               b.isexecute = 1 AND
               b.billdate <= '2005-02-28'
         GROUP BY a.partid
) tmp4 ON tmp1.PARTID = tmp4.PARTID) b
on a.partid=b.partid

 

 

 

 

 

 

//ok

 

SELECT ISNULL(a.Expr1, 0) AS xh, ISNULL(b.Expr1, 0) AS jc, b.Expr1 - a.Expr1 AS qc,
      b.PARTNAME,a.rk,a.rkt,a.ck,a.ckt
FROM (SELECT isnull(tmp1.sumquantity, 0) - isnull(tmp2.sumquantity, 0)
              - isnull(tmp3.sumquantity, 0) + isnull(tmp4.sumquantity, 0) AS Expr1,
isnull(tmp1.sumquantity,0) as rk,isnull(tmp2.sumquantity,0) as ck,
isnull(tmp3.sumquantity,0) as rkt,isnull(tmp4.sumquantity,0) as ckt,
              TMP.PARTNAME, tmp.partid
        FROM (SELECT a.PARTID, a.PARTNAME
                FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
                      dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
                WHERE (b.BILLDATE <= '2005-02-28')
                GROUP BY a.PARTID, a.PARTNAME) tmp LEFT OUTER JOIN
                  (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
                 FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
                       dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
                 WHERE (b.BILLDATE BETWEEN '2005-02-27' AND '2005-02-28')
                 GROUP BY a.PARTID, a.PARTNAME) tmp1 ON
              tmp.partid = tmp1.partid LEFT OUTER JOIN
                  (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
                 FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
                       dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
                 WHERE (b.BILLDATE BETWEEN '2005-02-27' AND '2005-02-28')
                 GROUP BY a.PARTID, a.PARTNAME) tmp2 ON
              tmp.PARTID = tmp2.PARTID LEFT OUTER JOIN
                  (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                 FROM reimbursebillbody a, reimbursebillhand b
                 WHERE a.billcode = b.billcode AND b.reimbursetype = '1' AND
                       b.isexecute = 1 AND b.billdate BETWEEN '2005-02-27' AND
                       '2005-02-28'
                 GROUP BY a.partid) tmp3 ON
              tmp.PARTID = tmp3.PARTID LEFT OUTER JOIN
                  (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                 FROM reimbursebillbody a, reimbursebillhand b
                 WHERE a.billcode = b.billcode AND b.reimbursetype = '2' AND
                       b.isexecute = 1 AND b.billdate BETWEEN '2005-02-27' AND
                       '2005-02-28'
                 GROUP BY a.partid) tmp4 ON tmp.PARTID = tmp4.PARTID)
      a RIGHT OUTER JOIN
          (SELECT isnull(tmp1.sumquantity, 0) - isnull(tmp2.sumquantity, 0)
               - isnull(tmp3.sumquantity, 0) + isnull(tmp4.sumquantity, 0) AS Expr1,
               TMP1.PARTNAME, tmp1.partid
         FROM (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
                 FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
                       dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
                 WHERE (b.BILLDATE <= '2005-02-28')
                 GROUP BY a.PARTID, a.PARTNAME) tmp1 LEFT OUTER JOIN
                   (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY)
                        AS sumquantity
                  FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
                        dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
                  WHERE (b.BILLDATE <= '2005-02-28')
                  GROUP BY a.PARTID, a.PARTNAME) tmp2 ON
               tmp1.PARTID = tmp2.PARTID LEFT OUTER JOIN
                   (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                  FROM reimbursebillbody a, reimbursebillhand b
                  WHERE a.billcode = b.billcode AND b.reimbursetype = '1' AND
                        b.isexecute = 1 AND b.billdate <= '2005-02-28'
                  GROUP BY a.partid) tmp3 ON
               tmp1.PARTID = tmp3.PARTID LEFT OUTER JOIN
                   (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                  FROM reimbursebillbody a, reimbursebillhand b
                  WHERE a.billcode = b.billcode AND b.reimbursetype = '2' AND
                        b.isexecute = 1 AND b.billdate <= '2005-02-28'
                  GROUP BY a.partid) tmp4 ON tmp1.PARTID = tmp4.PARTID) b ON
      a.partid = b.partid


      //
      {
 CREATE PROCEDURE sp_stockSFC
 @date1 datetime,
 @date2 datetime

AS

select * into tmpkk from
(

SELECT ISNULL(a.Expr1, 0) AS xh, ISNULL(b.Expr1, 0) AS jc, b.Expr1 - a.Expr1 AS qc,
      b.PARTNAME,b.partid,a.rk,a.rkt,a.ck,a.ckt
FROM (SELECT isnull(tmp1.sumquantity, 0) - isnull(tmp2.sumquantity, 0)
              - isnull(tmp3.sumquantity, 0) + isnull(tmp4.sumquantity, 0) AS Expr1,
isnull(tmp1.sumquantity,0) as rk,isnull(tmp2.sumquantity,0) as ck,
isnull(tmp3.sumquantity,0) as rkt,isnull(tmp4.sumquantity,0) as ckt,
              TMP.PARTNAME, tmp.partid
        FROM (SELECT a.PARTID, a.PARTNAME
                FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
                      dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
                WHERE (b.BILLDATE <= @date2)
                GROUP BY a.PARTID, a.PARTNAME) tmp LEFT OUTER JOIN
                  (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
                 FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
                       dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
                 WHERE (b.BILLDATE BETWEEN @date1 and @date2)
                 GROUP BY a.PARTID, a.PARTNAME) tmp1 ON
              tmp.partid = tmp1.partid LEFT OUTER JOIN
                  (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
                 FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
                       dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
                 WHERE (b.BILLDATE BETWEEN @date1 and @date2)
                 GROUP BY a.PARTID, a.PARTNAME) tmp2 ON
              tmp.PARTID = tmp2.PARTID LEFT OUTER JOIN
                  (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                 FROM reimbursebillbody a, reimbursebillhand b
                 WHERE a.billcode = b.billcode AND b.reimbursetype = '1' AND
                       b.isexecute = 1 AND b.billdate BETWEEN @date1 AND @date2
                 GROUP BY a.partid) tmp3 ON
              tmp.PARTID = tmp3.PARTID LEFT OUTER JOIN
                  (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                 FROM reimbursebillbody a, reimbursebillhand b
                 WHERE a.billcode = b.billcode AND b.reimbursetype = '2' AND
                       b.isexecute = 1 AND b.billdate BETWEEN @date1 AND @date2
                 GROUP BY a.partid) tmp4 ON tmp.PARTID = tmp4.PARTID)
      a RIGHT OUTER JOIN
          (SELECT isnull(tmp1.sumquantity, 0) - isnull(tmp2.sumquantity, 0)
               - isnull(tmp3.sumquantity, 0) + isnull(tmp4.sumquantity, 0) AS Expr1,
               TMP1.PARTNAME, tmp1.partid
         FROM (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY) AS sumquantity
                 FROM dbo.PARTSINPUTBODY a LEFT OUTER JOIN
                       dbo.PARTSINPUTHAND b ON a.BILLCODE = b.BILLCODE
                 WHERE (b.BILLDATE <= @date2)
                 GROUP BY a.PARTID, a.PARTNAME) tmp1 LEFT OUTER JOIN
                   (SELECT a.PARTID, a.PARTNAME, SUM(a.QUANTITY)
                        AS sumquantity
                  FROM dbo.PARTSOUTPUTBODY a LEFT OUTER JOIN
                        dbo.PARTSOUTPUTHAND b ON a.BILLCODE = b.BILLCODE
                  WHERE (b.BILLDATE <= @date2)
                  GROUP BY a.PARTID, a.PARTNAME) tmp2 ON
               tmp1.PARTID = tmp2.PARTID LEFT OUTER JOIN
                   (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                  FROM reimbursebillbody a, reimbursebillhand b
                  WHERE a.billcode = b.billcode AND b.reimbursetype = '1' AND
                        b.isexecute = 1 AND b.billdate <= @date2
                  GROUP BY a.partid) tmp3 ON
               tmp1.PARTID = tmp3.PARTID LEFT OUTER JOIN
                   (SELECT isnull(SUM(a.quantity), 0) AS sumquantity, a.partid
                  FROM reimbursebillbody a, reimbursebillhand b
                  WHERE a.billcode = b.billcode AND b.reimbursetype = '2' AND
                        b.isexecute = 1 AND b.billdate <= @date2
                  GROUP BY a.partid) tmp4 ON tmp1.PARTID = tmp4.PARTID) b ON
      a.partid = b.partid


) tmmm
GO

 

      }


      if exists (select * from sysobjects where id = object_id(N'[tmpkk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)  drop table [tmpkk]


DECLARE @RC int
DECLARE @date1 datetime
DECLARE @date2 datetime
SELECT @date1 = '2005-02-25'
SELECT @date2 = '2005-02-28'
EXEC @RC = [wy].[dbo].[sp_StockSFC] @date1, @date2
DECLARE @PrnLine nvarchar(4000)
PRINT '存储过程: wy.dbo.sp_StockSFC'
SELECT @PrnLine = ' 返回代码 = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine


select * from tmpkk

xluke2
关注
The Learning route of GNN
SimonChen
10-15 589
The Learning route of GNN CHEN JIE Note：图神经网络的相关实战教程及其缺乏，如有看到相关内容，可以添加到群在线文档之中。 图神经网络基础知识 台大李宏毅的GNN课（很通俗易懂，较为推荐） 链接：(1/2) https://www.youtube.com/watch?v=eybCCtNKwzA&ab_channel=Hung-yiLee ​ (2/2)https://www.youtube.com/watch?v=M9ht8vsVEw8&t=1
华东理工大学计算机图形答案,华东理工大学信息科学与工程学院硕士研究生导师张静...
weixin_28968525的博客
07-26 1138
1978年11月生，华东理工大学副教授，硕士生导师。2007年1月毕业于复旦大学计算机学院，获计算机应用专业博士学位。同年2月进入华东理工大学计算机科学与工程系任教。2019年7月被评为副教授。2015年3月-2016年3月，在美国佐治亚理工大学做访问学者。主要从事多媒体信息检索方面的研究工作，研究内容包括：计算机视觉、图像理解、视频语义分析等。在SCI检索的国际期刊及EI检索的国际会议上发表学术...
php mysql 学习,php+mysql完全学习手册源码
weixin_31539351的博客
03-09 203
【实例简介】《php+mysql完全学习手册》(黄桂金、于永军)源码【实例截图】【核心代码】b82c182d-8fbd-4888-854f-5dc80db47e47└── php+mysql└── downloads├── 第11章│ ├── conn.php│ ├── del.php│ ├── de.php│ ├── field.php│ ├── inse.php│ ├─...
js ajax ext jquery sturts 常见脚本
u012291104的专栏
11-05 1102
Extjs ext导入  工单导入 cookie 创建 Ext.state.Manager. public static void main(String[] args) {  Calendar calendar = new GregorianCalendar();  String N = calendar.get(Calendar.YEAR)+"";  String Y = ca
mysql最简单的存储过程_mysql学习之写几个最简单的存储过程
weixin_30141959的博客
01-19 352
写在前面:文章整理上传于2017年9月26日 ,是博主学习燕十八的视频后自己整理的笔记 ,如果有错误,你来打我呀主要是存储过程的简单使用 ,至于什么是存储过程,为什么用过程,什么时候用过程,网上有好多,我不想在这里写了.1.存储过程语法:create procedure 过程名称(参数)begin//核心代码end;最简单的示例:create procedure p1()beginselect '...
C:/Users/yuejie/PycharmProjects/pythonProject/mp4/20240119_213855.mp4
01-21
url = "C:/Users/yuejie/PycharmProjects/pythonProject/mp4/20240119_213855.mp4" filename = "video.mp4" try: urllib.urlretrieve(url, filename) print("视频下载成功！") except Exception: print("视频...
streamlit run C:\Users\yuejie\PycharmProjects\pythonProject\答题\v3.py [ARGUMENTS]
02-19
streamlit是一个用于创建数据应用程序的Python库。它可以帮助你快速构建交互式的Web应用程序，而无需编写大量的代码。你可以使用streamlit run命令来运行你的应用程序。 在你提供的引用中，并没有与streamlit run...
streamlit run C:\Users\yuejie\PycharmProjects\pythonProject\网管\newa.py [ARGUMENTS]
02-12
streamlit是一个用于创建数据应用程序的Python库。它可以帮助你快速构建交互式的数据可视化界面。要运行一个streamlit应用程序，你可以使用以下命令： ```shell streamlit run <文件路径> ``` 其中，`<文件路径>`是...
npm ERR! code 1 npm ERR! path E:\yuejie\genious-admin\node_modules\node-sass npm ERR! command failed npm ERR! command C:\Windows\system32\cmd.exe /d /s /c node scripts/build.js npm ERR! Building: D:\Program Files (x86)\nodejs\node.exe E:\yuejie\genious-ad
06-21
### 解决方案 在 Windows 环境下，`node-sass` 的 `build.js` 脚本失败通常是由于 Node.js 版本不匹配、依赖版本冲突或网络问题引起的。以下是具体的解决方法： #### 1....确保项目目录中不存在旧的 `node_modules` ...
信捷PLC与台达伺服A2B2通讯实现高效拧螺丝动作：速度模式、扭力限制及锁紧信号IO输出
07-23
内容概要：本文详细介绍了如何利用信捷PLC与台达伺服A2/B2进行通讯，实现高效的拧螺丝动作。主要内容涵盖速度模式的配置、扭力限制的设置以及锁紧信号的IO输出。文中提供了具体的硬件接线方法，如伺服CN1接口与PLC输出端的连接细节，确保了系统的稳定性和可靠性。同时，还给出了详细的参数设置和PLC程序示例，帮助用户快速理解和应用。此外，文章特别强调了扭矩监控的重要性，并提供了一些实用的避坑指南，如伺服使能的正确接法、脉冲口抗干扰措施以及扭力限制值的调整技巧。 适合人群：从事自动化设备安装、调试的技术人员，尤其是对PLC和伺服系统有一定了解的工程师。 使用场景及目标：适用于需要实现自动化拧螺丝操作的企业或实验室，旨在提高生产效率和产品质量。通过学习本文，读者可以掌握信捷PLC与台达伺服的具体配置方法，从而顺利完成拧螺丝任务。 其他说明：本文不仅提供了理论指导，还附带了大量的实战经验和技巧，有助于读者在实际工作中避免常见错误，提升工作效率。
汽车安全领域中基于Simulink的ABS模型仿真与防抱死制动系统建模 仿真技术 详细版
最新发布
07-23
内容概要：本文深入探讨了利用Simulink进行汽车防抱死制动系统（ABS）的建模与仿真的方法。主要内容涵盖Simulink环境下ABS模型的具体构建，包括速度传感器模块和制动压力控制模块的设计，以及详细的仿真分析。文中不仅展示了有无ABS系统在紧急制动情况下的性能差异，还提供了具体的Matlab代码片段，解释了ABS控制系统的工作原理及其重要性。通过对比实验，证明了ABS系统能够显著缩短刹车距离并提高行车安全性。 适合人群：汽车工程专业学生、从事汽车安全技术研发的工程师和技术爱好者。 使用场景及目标：帮助读者掌握ABS系统的基本原理和建模技巧，提升对汽车主动安全技术的理解，适用于教学培训、科研项目和个人学习等场景。 其他说明：文章附带了完整的Word文档说明和Simulink模型文件，便于读者进一步理解和实践。
V公司高效稳定的汽车零部件开发工具：全套OSEK NM协议栈源代码及配置功能，轻松完成集成，量产保证
07-23
内容概要：本文详细介绍了汽车零部件开发巨头V公司提供的OSEK NM协议栈源代码及其配置功能。OSEK NM是一种专为汽车网络管理设计的通信协议，由韩国汽车工业标准化组织制定。V公司提供的这套工具集不仅代码结构清晰、模块化程度高，而且具有高效稳定的特性，适用于汽车零部件的开发。文中具体解析了源代码的结构和各模块的功能，特别是网络管理模块的核心代码，展示了V公司在网络管理方面的精细控制。此外，文章还详细描述了集成步骤和性能优化方法，强调了V公司提供的技术支持和优化工具。最终，V公司的OSEK NM协议栈因其稳定性和量产保证，成为了汽车零部件开发的首选工具。 适合人群：从事汽车零部件开发的技术人员、嵌入式系统工程师、汽车电子工程师。 使用场景及目标：① 快速集成并使用OSEK NM协议栈进行汽车零部件开发；② 提升网络管理和数据传输的效率；③ 实现高效稳定的汽车网络管理系统。 其他说明：V公司提供的OSEK NM协议栈不仅简化了开发流程，还确保了产品的量产可行性，适用于现代汽车工业的发展需求。
嵌入式系统中串口转以太网通信的CC++实现及其应用
07-23
内容概要：本文档详细介绍了使用C语言和C++实现串口转以太网通信的技术细节。它不仅涵盖了多路网口和串口之间的双向数据转换，还支持UDP和TCP两种连接方式。文中特别强调了通过Qt5.10.1平台和QSerialPort类来构建这一通信机制的具体方法。此外，文档还提供了丰富的辅助工具如16进制数据发送窗口、接收窗口、自动连接功能以及配置文件管理等特性。为了便于开发者理解和使用，所有源代码均配有详细的注释和技术文档。 适合人群：对嵌入式系统开发感兴趣的工程师或者有一定编程经验的研发人员。 使用场景及目标：适用于需要将传统RS232/485等串行接口设备接入现代网络环境的情况，比如工业自动化控制系统、智能家居产品或其他物联网应用场景。通过学习本文档，读者能够掌握如何利用现有硬件资源搭建高效稳定的串口转以太网解决方案。 其他说明：该文档不仅限于理论讲解，还包括实际项目案例分享，帮助读者更好地理解整个系统的运作流程。同时提醒使用者确保源码放置于纯英文路径下以便正确编译运行。
几何测量中最小二乘法评估直线度、平面度及圆度的C#实现 - 最小二乘法
07-23
内容概要：本文详细介绍了最小二乘法在几何测量领域的应用，特别是针对直线度、平面度和圆度的评估方法。文中不仅解释了最小二乘法的基本原理及其在不同几何形状拟合中的具体步骤，还提供了完整的C#实现代码。对于每种几何形状，作者都列出了详细的计算流程，从数据点的初始化到最后的最佳拟合结果确定，确保读者能够理解和实现这一数学优化技术。 适合人群：从事几何测量工作的技术人员以及对最小二乘法感兴趣的开发者。 使用场景及目标：适用于需要精确评估几何形状特征的应用场合，如机械制造、质量检测等领域。通过学习本文，读者可以掌握如何使用最小二乘法进行直线度、平面度和圆度的计算，从而提高测量精度。 阅读建议：由于涉及到具体的数学推导和编程实现，建议读者具备一定的数学基础和C#编程经验，在阅读过程中结合实际案例进行练习，以便更好地理解最小二乘法的应用。
风力发电光伏发电用电负荷数据（部分年份具体看数据描述内容）
07-23
数据名称：风力发电、光伏发电、用电负荷数据 数据年份：光伏发电（2007-2020年）、风力发电（2019年）、用电负荷（2016-2018） 光伏发电：采样结束时刻、采样起始时刻、时间间隔、气温、方位角、云层不透明度、露点温度、DHI、DNI、GHI、GTI（固定倾角辐射）、GTI（跟踪倾角辐射）、实际功率、大气可降水量、相对湿度、降雪深度、地面气压、高度10m风向、高度10m风速、天顶角 风力发电：时间、风电#1(48.3)、风电#2(43.2)、风电#3(100) 负荷电气：时间、负荷、最高温度℃、最低温度℃、平均温度℃、相对湿度(平均)、降雨量（mm）。资源来源于网络分享，仅用于学习交流使用，请勿用于商业，如有侵权请联系我删除！
yolo11-pyqt5-gui车牌检测-交通管理和车辆识别系统+数据集+训练好的模型+pyqt5可视化界面.zip
07-23
yolo11-pyqt5-gui车牌检测-交通管理和车辆识别系统+数据集+训练好的模型+pyqt5可视化界面
20250704-基于强化学习在云计算环境中的虚拟机资源调度研究
07-23
20250704-基于强化学习在云计算环境中的虚拟机资源调度研究
2017年中国地区投入产出表31个省市42部门
07-23
2017年各省份投入产出表。资源来源于网络分享，仅用于学习交流使用，请勿用于商业，如有侵权请联系我删除！
TriCore TC1.6.2 架构手册-中英文版本.zip
07-23
TriCore TC1.6.2 架构概述TriCore TC1.6.2 架构是 Infineon Technologies AG 公司开发的一款 32 位统一处理器核心，主要应用于微控制器领域。该架构的主要特点是高性能、低功耗、灵活的架构设计和强大的指令集架构。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值