我想您可以使该列成为防止重复的主键，尽管这是一种hack。您可以稍后删除密钥。
---- Create the variables for the random number generationDECLARE @Random INT;DECLARE @Upper INT;DECLARE @Lower INT;DECLARE @Index integer---- This will create a random number between 1 and 999SET @Lower = 1 ---- The lowest random numberSET @Upper = 999 ---- The highest random numberSET @Index = 0 --- A while loop counter--- Loop from 0 to 10WHILE @Index < 10BEGIN SELECT 'loop counter = ', @index SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0) --Insert @Random here. SET @index = @index + 1END
