更新时间:2023-02-06 08:54:24
将@Length设置为你所需要的。根据需要添加更多的sys.objects副本。
SET the @Length to what you need. Add more copies of sys.objects as necessary.
DECLARE @Length INT
SET @Length = 10000
DECLARE @RandomDigits VARCHAR(MAX)
SET @RandomDigits = ''
SELECT TOP (@Length) @RandomDigits = @RandomDigits + RIGHT(CHECKSUM(NEWID()), 1)
FROM sys.objects a, sys.objects b, sys.objects c
SELECT @RandomDigits