Advertisement
MatthijsFontys

Create random messages

Nov 18th, 2019
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.18 KB | None | 0 0
  1.   DECLARE @cnt INT = 0;
  2.  
  3.     WHILE @cnt < 1000
  4.     BEGIN
  5.        INSERT INTO [MESSAGE] (USERID, CONTENT) VALUES ( CAST(RAND() * 5 AS INT), CAST(@cnt AS VARCHAR) )
  6.        SET @cnt = @cnt + 1;
  7.     END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement