반응형
DECLARE @z_start INT
SET @z_start = 0
DECLARE @z_end INT
SET @z_end = 0
WHILE (@z_start <= 14) BEGIN
    IF(@z_start != 0 AND @z_end != 14)
        WHILE (@z_end <= 14) BEGIN
            INSERT INTO [디비].[dbo].[테이블] 

([컬럼1],[컬럼2]) VALUES (1,2)

            SET @z_end = @z_end + 1
        END
        SET @z_start = @z_start + 1
        SET @z_end = 0
    END
요케 하니까 14개 데이타 슉 ~ 한방




반응형

+ Recent posts