数据库中批量插入一笔数据：三层循环添加一笔数据

数据库中批量插入一笔数据：三层循环添加一笔数据

declare @StockLocationID nvarchar(80);
declare @Code nvarchar(80);
declare @Area int;
declare @Floor int;
declare @Col int;
declare @LR int;


set @Area = 2;    //库区1和库区2分别设置插入
set @Floor = 1;
set @Col = 1;
set @LR = 3;      //设置库区时，重新设置数值

while(@Floor < 15) 
    begin
    
        while(@Col < 14)
            begin
            
              while(@LR < 5) 
              begin
			    set @Code = cast(@Area as nvarchar(80))+'_'+cast(@Floor as nvarchar(80))+'_'+cast(@Col as nvarchar(80))+'_'+cast(@LR as nvarchar(80))
                insert into dbo.mStock_Location(StockLocationID,Code,Area,Floor,Col,LR)
                values(newid(),@Code,@Area,@Floor,@Col,@LR)
              set @LR = @LR + 1
              end
			   
            set @Col = @Col + 1
			set @LR = 3
            end
	set @Col = 1
    set @Floor = @Floor + 1
    end

删除表中全部数据

delete dbo.mStock_Location

查询表中一共有多少笔数据

select count(*) from dbo.mStock_Location