sql server isnull 和 case cast 函数

isnull 如果为null 的时候的替换字符

 

select top 10 isnull(bjsj,'空') as bjsj from spworklist

 

case 条件判断dqzt 字段 -1 返回当前-1 如果是 3 返回当前是3 否则不是-1也不是-3

 

select top 10 case dqzt when -1 then '当前是-1' when 3 then '当前是3'  else '不是-1也不是-3'  end as dqzt  from spworklist 

 

cast类型转换函数

 

-- Use CAST.
USE pubs
GO
SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales
FROM titles
WHERE CAST(ytd_sales AS char(20)) LIKE '3%'
GO

-- Use CONVERT.
USE pubs
GO
SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales
FROM titles
WHERE CONVERT(char(20), ytd_sales) LIKE '3%'
GO