Auto Gen Random Keys by MSSQL

自動產生亂數序號

		DECLARE @start INT = 1;
		DECLARE @end INT = 50;	
		WITH #KEYS AS (
			SELECT @start AS Number, REPLACE(LEFT(NEWID(), 18), '-', '') AS [KEY]
			UNION ALL
			SELECT Number + 1, REPLACE(LEFT(NEWID(), 18), '-', '') AS [KEY]
			FROM  #KEYS
			WHERE Number < @end
		)
		SELECT * FROM #KEYS OPTION (MAXRECURSION 0)