34,591
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
chuifengde 2006-10-18
- 打赏
- 举报
declare @a decimal(30,5)
set @a=20398482934.2342
select left(ltrim(@a),charindex('.',@a)-1)
set @a=20398482934.2342
select left(ltrim(@a),charindex('.',@a)-1)
marco08 2006-10-18
- 打赏
- 举报
declare @f decimal(10, 2)
set @f=1.9
select cast(@f as int)
set @f=1.9
select cast(@f as int)
marco08 2006-10-18
- 打赏
- 举报
select cast(1.9 as int)
