22,301
社区成员




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))