34,575
社区成员
发帖
与我相关
我的任务
分享
DECLARE @Name varchar(50)
SET @Name=20.00
SELECT CAST(Cast((@Name) As DECIMAL(10,2)) AS INT ),Cast((@Name) As DECIMAL(10,2))
/*
----------- ---------------------------------------
20 20.00
*/
DECLARE @Name varchar(50)
SET @Name=20.00
SELECT CAST(Cast((@Name) As DECIMAL(10,2)) AS INT )