1，CONVERT和BETWEEN。。。AND

SELECT DWMC,SUM(CK.ZJE) AS SJHK,SUM(CK.ZCJE) AS ZCJE,SUM(CK.BZJE) AS BZJE ,SUM(JSJE) AS JSJE FROM CKDXX AS CK

 INNER JOIN SGDWJBXX AS SG ON SG.DWDM=CK.SGDW

  WHERE JSJE!=0 AND CONVERT(DATETIME,CK.KDRQ) BETWEEN '2007-03-24' AND '2007-03-30' GROUP BY DWMC ORDER BY DWMC

2，把查询结果SQL语句里作为一个新字段，查询结果为空则赋0值

SELECT DISTINCT ISNULL((SELECT SUM(ZXSRS) FROM XXJBXX WHERE XXJBXX.XXDM LIKE '" + xxdm + "%' AND XXLB LIKE '" + xxlb + "%'),0) AS ZRS, SUM(TJ.XYS) AS XYS, SUM(TJ.XYE) AS XYE

 FROM ZCFLTJ AS TJ  INNER JOIN XXJBXX AS XX ON TJ.XXDM = XX.XXDM

 WHERE TJ.XXDM LIKE'" + xxdm + "%' AND  XX.XXLB LIKE '" + xxlb + "%' AND TJ.ND='" + year + "' AND TJ.FL='" + flmc + "'

3，把一个字段值取最后四位后，求其最大值

select max(convert(int,(right(DM,4)))) from DM_ZCFL where dm like '"+fl+"%' and len(dm)="+(fl.Length+4)+" and flbz=0"

评论