concat两个整数并在SQL中将结果作为字符串

你可以科协的整数字段为varchar，然后将它们连接起来，只要你想。

DECLARE @ID INT DECLARE @Number INTSET @ID = 101 SET @Number = 9SELECT CAST(@ID AS VARCHAr(10) ) +'.'+ CAST(@Number AS VARCHAr(10) )