590
社区成员
发帖
与我相关
我的任务
分享
SELECT CAST('123.000' AS NUMERIC(16,0))
---------------------------------------
123
(1 行受影响)
DECLARE @t TABLE (
bid VARCHAR(100)
)
INSERT INTO @t VALUES ('12345.000')
INSERT INTO @t VALUES ('11111.000')
SELECT PARSENAME(bid,2) AS bid FROM @t
/*
bid
12345
11111
*/
Select SUBSTRING(bid,0,CHARINDEX('.',bid)) from 表