存储过程循环插入数据

 

存储过程循环插入数据

Declare @Count int;
declare @MaxCount int;
declare @id tinyint;
declare @name char(40);
declare @order int;
declare @dataname char(40);
declare @tmp  char(40);

set @Count = 105;
set @MaxCount = 255;
set @id = 30;
set @name = 'TEST用'
set @order = 5;
set @dataname = 'サークル紹介Test';
while (@Count < @MaxCount)
Begin
set @Count = @Count + 1;
set @order = @order + 1;
set @dataname = @dataname;
INSERT INTO [DB].[dbo].[CM]
           ([id]
           ,[name]
           ,[data_id]
           ,[data_name]
           ,[sys_kind]
           ,[status]
           ,[insert_date]
           ,[update_date]
           ,[update_user_id]
           ,[update_user_name]
           ,[order]
           ,[explanation]
           ,[fix_flag])
     VALUES
           (@id,@name,@Count,
            @dataname,1,'true',getdate(),getdate(),
           '0000101', 'test1',@order,'','1')
END