/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
DECLARE @ID INT = 10000 while @ID < 10010 BEGIN DECLARE @location VARCHAR(1000) = '' DECLARE @i INT = 0 while @i<1000 BEGIN SET @location = @location + CHAR(33 + CAST(CEILING(rand() * 80) AS INT)) SET @i = @i+1 END SELECT @location SET @ID = @ID +1 END