-
转换数据类型
-
convert
-
-- 参数1是转成的类型,参数2转换的数据
-
declare @number int
set @number = 3
select convert(char(1),@number) as 转换后
-
-
cast
-
使用cast(表达函数)和as进行连用
-
select 'student age is' + CAST(10 as varchar )
-
-
11-20
1691