Skip to content

Instantly share code, notes, and snippets.

@tugberkugurlu
Created June 23, 2016 09:48
Show Gist options
  • Save tugberkugurlu/7de6db0f9f11003937ed09f55c0a1d8a to your computer and use it in GitHub Desktop.
Save tugberkugurlu/7de6db0f9f11003937ed09f55c0a1d8a to your computer and use it in GitHub Desktop.
T-SQL WHILE Loop and Insert bunch of stuff
USE BritishProverbs
GO
DECLARE @Count AS INT = 100000;
DECLARE @Lorem AS nvarchar(max) = 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.';
WHILE (@Count > 1)
BEGIN
INSERT INTO Proverbs VALUES (1, @Lorem, 1, SYSDATETIMEOFFSET());
SET @Count = (@Count - 1);
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment