SQL 语句,类型转换
摘要:declare @f float;declare @i int;set @f = 123.789;--set @i = convert(int, @f)--set @i = cast(@f as int)--set @i = ROUND(@f, 0, 1);//直接截取set @i = ROUND(@f, 0); //四舍五入select @i
阅读全文
posted @ 2013-01-23 13:28