랜덤 알파펫 조합하기

테이블에 랜덤 문자열을 저장하는 절차

CREATE TABLE [dbo].[Table_1](
	[SEQ] [int] NOT NULL,
	[USERID] [varchar](10) NULL
) 

데이타 100,000 건 입력하기

DECLARE @outer_index int
SET @outer_index = 1

WHILE @outer_index <= 100000
BEGIN

	DECLARE @rnd_num tinyint, @index int, @char char(1), @rndchar VARCHAR(10)
	SET @index = 1
	SET @rndchar = ''

	WHILE @index < 6
	BEGIN
		SET @rnd_num = convert( int, (rand() * 52)+1  )

		SET @char = SUBSTRING('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',@rnd_num ,1)
		SET @rndchar = @rndchar + @char
			
		SET @index = @index + 1
	END

	INSERT INTO dbo.Table_1(SEQ, USERID) VALUES(@outer_index, @rndchar)
	
	SET @outer_index = @outer_index + 1
END