怎样使varchar转换成DECIMAL并保留六位小数谢谢

create table #temp(amount varchar(100))

insert #temp

select '99.99'



--#1.

select amount=CAST(amount as decimal(38, 6)) from #temp

select convert(decimal(38,6),amount) from #temp

--#2.

alter table #temp

alter column amount decimal(38, 6)



select * from #temp

--result

/*

amount

99.990000

*/

--如果直接改变列的属性,用

Alter table tbname alter column colunmname decimal(38,6)

--如果在检索中转为相应的数据类型,则:

select convert(decimal(38,6),columnname) from tbname

 

cast col as dec(38,6)

cast(varchar as decimal(18,6))