摘要:
1、SQLSERVER中的写法:--更新上传点表数据 update ID_MASTER set ONCALL_ID=Tb_Points.ONCALL_ID, ServerName=Tb_Points.ServerName, SISCode = Tb_Points.SISCode, LOC_ID = Tb_Points.JZCode, Unit= Tb_Points.Unit, Descriptio... 阅读全文
摘要:
1. CASE 写法 SELECT LogID,UserID,LogTime,Url,Description,( case when OperateType = 0 then '新增' when OperateType=1 then '修改' else '删除' end ) FROM LOG 2.DECODE的写法: SELECT LogID,UserID,LogTime,Url... 阅读全文