06 2021 档案
摘要:SELECT ISNULL(T1.KHMC, '总计')客户名称, ISNULL(T1.DJMC, '小计')单据名称, CAST(SUM(T1.SL) AS INT)数量 FROM ( SELECT vl.DM1, k.KHMC, vl.DJMC, vl.SL FROM VW_LSXHDMX AS
阅读全文
摘要:SELECT * FROM ( SELECT vl.DM1 AS 客户代码, k.KHMC AS 客户名称, vl.SPDM AS 商品代码, s.SPMC AS 商品名称, CAST(SUM(SL) AS INT) AS 销售数量, DENSE_RANK()OVER(PARTITION BY vl
阅读全文
摘要:1 判断数据库是否存在 if exists (select * from sys.databases where name = ’数据库名’) drop database [数据库名] 2 判断表是否存在 if exists (select * from sysobjects where id =
阅读全文