34,587
社区成员
发帖
与我相关
我的任务
分享
DECLARE @a money
set @a=296
select cast((@a/100) as int)//输出3
--要得出2、96,如下:
select cast(sl as int)/100 from # --输出2
select cast(sl%100 as int) from # --输出96
[/quote]
这个是好办法,是对的。select cast(sl/100 as int) from #
这句话我在sql 2005里没有运行成功!
DECLARE @a money
set @a=296
select cast((@a/100) as int)//输出3
--要得出2、96,如下:
select cast(sl as int)/100 from # --输出2
select cast(sl%100 as int) from # --输出96
---建表
create table #
(sl money)
---insert data
insert #
select 296
---为什么以下结果不同
select cast(sl/100 as int) from #
select cast(296.0000/100 as int)