在mssql 的存储过程中有这么个update更新临时表的语句 请教在mysql存储过程中的写法
UPDATE #TEMP
SET WBJF = ISNULL((SELECT ISNULL(WBJF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
WBDF = ISNULL((SELECT ISNULL(WBDF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
JFSL = ISNULL((SELECT ISNULL(JFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
DFSL = ISNULL((SELECT ISNULL(DFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBJ = ISNULL((SELECT ISNULL(JFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBD = ISNULL((SELECT ISNULL(DFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0), YEWB = ISNULL((SELECT SUM(ISNULL(WBJF,0)-ISNULL(WBDF,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YESL = ISNULL((SELECT SUM(ISNULL(JFSL,0)-ISNULL(DFSL,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YE = ISNULL((SELECT SUM(ISNULL(JFSJ,0)-ISNULL(DFSJ,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0)
WHERE XH = 2
UPDATE #TEMP
SET WBJF = ISNULL((SELECT ISNULL(WBJF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
WBDF = ISNULL((SELECT ISNULL(WBDF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
JFSL = ISNULL((SELECT ISNULL(JFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
DFSL = ISNULL((SELECT ISNULL(DFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBJ = ISNULL((SELECT ISNULL(JFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBD = ISNULL((SELECT ISNULL(DFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0), YEWB = ISNULL((SELECT SUM(ISNULL(WBJF,0)-ISNULL(WBDF,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YESL = ISNULL((SELECT SUM(ISNULL(JFSL,0)-ISNULL(DFSL,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YE = ISNULL((SELECT SUM(ISNULL(JFSJ,0)-ISNULL(DFSJ,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0)
WHERE XH = 2
解决方案 »
- 有没有针对所有表的触发器?
- mysql 6.0 官方网站上怎么找不到呢?哪位能提供连接?
- MYSQL 判断用户然后进行不同那个
- 有什么办法可以查SQL数据库某个表的表头
- MySQL Query Browser无法正确显示中文?
- MySQL,开新用户,限制其权限问题
- 有没有可以使用代理的管理MYSQL的工具
- 请教一个简单的关于统计的sql
- 急!!ERROR 1064 (42000) at line 7: You have an error in your SQL syntax;
- 采用OpenReplicator解析MySQL binlog遇到的问题
- 求一条SQL语句,要求把A表某个字段的值,赋成这A表的ID=31的这条记录的这个字段的值
- 急!更新大数据量的字段值时,运行很久都没返回,CPU占100%,如何解决???
临时表不能reopen