你可以科协的整数字段为varchar,然后将它们连接起来,只要你想。
DECLARE @ID INT DECLARE @Number INTSET @ID = 101 SET @Number = 9SELECT CAST(@ID AS VARCHAr(10) ) +'.'+ CAST(@Number AS VARCHAr(10) )

你可以科协的整数字段为varchar,然后将它们连接起来,只要你想。
DECLARE @ID INT DECLARE @Number INTSET @ID = 101 SET @Number = 9SELECT CAST(@ID AS VARCHAr(10) ) +'.'+ CAST(@Number AS VARCHAr(10) )