Last active
December 10, 2015 16:17
-
-
Save veysby/23312a7d92f8c2e0bd45 to your computer and use it in GitHub Desktop.
MSSQL: Create test table with random data
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT TOP 1000000 | |
IDENTITY(INT,1,1) AS UniqueInt, | |
CAST(NEWID() AS VARCHAR(36)) AS UniqueVarChar | |
INTO #TestTable | |
FROM Master.sys.All_Columns ac1 | |
CROSS JOIN Master.sys.All_Columns ac2 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment