sql server基本流程语句
1、IF...ELSE (sql server没有end,oracle中有)
DECLARE @co INT
SET @co=(SELECT COUNT(1) FROM HGOS_UC.dbo.Emp_Ora_Role eor WHERE eor.EmpId=539 AND eor.DepId=35)
IF @co=0
SELECT cr.*
FROM HGOS.dbo.CustomerRM AS cr
JOIN HGOS_WF.dbo.Task AS t ON cr.CompanyCode = t.OID
LEFT JOIN HGOS.dbo.Customer_Ora_R AS cor ON cor.CId=cr.Id
WHERE cor.OrgId=35
AND t.State = 4 AND ISNULL(t.IsDelete,0) = 0 AND ISNULL(cr.IsFreeze,0) = 0
AND cr.CreateUserId=539
ELSE
SELECT cr.*
FROM HGOS.dbo.CustomerRM AS cr
JOIN HGOS_WF.dbo.Task AS t ON cr.CompanyCode = t.OID
LEFT JOIN HGOS.dbo.Customer_Ora_R AS cor ON cor.CId=cr.Id
WHERE cor.OrgId=35
AND t.State = 4 AND ISNULL(t.IsDelete,0) = 0 AND ISNULL(cr.IsFreeze,0) = 0
2、CASE...WHEN...THEN
SELECT
t.ID,
CASE
WHEN STATE=1 THEN '审批中'
WHEN STATE=2 THEN '已通过'
ELSE '已驳回'
END
FROM HGOS_WF.dbo.Task AS t;
最新文章
- HTML5、canvas颜色拾取器
- cell跳出动画
- css中的列表属性
- AcceptEx与WSAEventSelect和Accept
- 如何为 setTimeout() 方法传参
- 转:Jmeter--google plugin插件监控被测系统资源方法
- php curl 访问 https站点
- socket__服务端于客户端
- 2017-2018-1 1623 bug终结者 冲刺006
- .NET反编译工具:de4dot
- Swift 访问控制
- 【译】你应该了解的JavaScript数组方法
- BZOJ1497 [NOI2006]最大获利 网络流 最小割 SAP
- 解决Requests中文乱码【有用】,读取htm文件 读取txt文件报错:UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc8 in position 0
- SharePoint Framework 企业向导(八)
- 入门智能家居,从 IFTTT 到 HomeKit 自动化(二)
- 2. CNN卷积网络-前向传播算法
- Struts2中使用OGNL表达式语言访问静态方法和静态属性
- λ(lambda)表达式
- nyoj139——康托展开