你可以科协的整数字段为varchar,然后将它们连接起来,只要你想。
DECLARE @ID INT
DECLARE @Number INT
SET @ID = 101
SET @Number = 9
SELECT CAST(@ID AS VARCHAR(10) ) +'.'+ CAST(@Number AS VARCHAR(10) )
concat两个整数并在SQL中将结果作为字符串
你可以科协的整数字段为varchar,然后将它们连接起来,只要你想。
DECLARE @ID INT
DECLARE @Number INT
SET @ID = 101
SET @Number = 9
SELECT CAST(@ID AS VARCHAR(10) ) +'.'+ CAST(@Number AS VARCHAR(10) )