TDJMQS保留测试SQL

最新推荐文章于 2024-04-24 15:25:55 发布

NO66781

最新推荐文章于 2024-04-24 15:25:55 发布

阅读量300

点赞数

CC 4.0 BY-SA版权

分类专栏： MSSQL

本文链接：https://blog.youkuaiyun.com/NO66781/article/details/93633071

MSSQL 专栏收录该内容

17 篇文章

订阅专栏

本文深入探讨了使用SQL语句进行数据插入的详细过程，通过一个具体案例，展示了如何将特定数据集插入到指定的数据库表中。文章涵盖了SQL INSERT语句的结构、参数设置以及与多表联接操作的结合应用。

INSERT INTO BillDetail_ZJK
            (kehu,rq,djbh,danwbh,spbh,shl,shl_kp,hshj,hshj_kp,hsje,hsje_kp,is_zx,beizhu_dj,beizhu_mx,time,spid,yuany,pihao,is_up,uptime)

SELECT '贵州大家康健(贵州)' AS kehu,a.rq,a.djbh,a.bendian AS danwbh
      ,c.spbh
      ,b.jlgg * b.diaocsl AS shl,b.jlgg * b.diaocsl AS shl_kp
      ,0 AS hshj,0 AS hshj_kp,0 AS hsje,0 AS hsje_kp
      ,'否' AS is_zx
      ,a.beizhu AS beizhu_dj,b.beizhu AS beizhu_mx
      ,CONVERT(CHAR(19),GETDATE(),120) AS TIME
      ,b.spid,'' AS yuany,'' AS pihao
      ,'N' AS is_up,'' AS uptime
FROM dbqhcrkhz AS a
     INNER JOIN dbqhcrkmx AS b ON a.djbh = b.djbh
     INNER JOIN spkfk AS c ON b.spid = c.spid
WHERE a.djbh='QHDZDA00047611  '