Cast 或 Convert
Select Cast(1 As Varchar(10))
Select Cast('1' As Int)Select Convert(Varchar(10),1)
Select Convert(Int,'1')
Select Cast(1 As Varchar(10))
Select Cast('1' As Int)Select Convert(Varchar(10),1)
Select Convert(Int,'1')
select @str = convert(varchar(50),@num)
或者:
select @num = convert(integer,@str)
declare @num int,@str varchar(50)
select @str = convert(varchar(50),@num)
或者:
select @num = convert(int,@str)