declare @strsku as varchar(15)
declare @sku int
set @sku = 60
while @sku <99
begin
set @strsku='0000000000000' + cast(@sku + 1 as char(39))
insert into dbo.syohinM
values( @str,'001' ,'BREAKFAST SET 2 WITH SOFT DRINK' ,100 ,200 ,0 ,0 ,'0' ,'0' ,'0' ,'0' ,'0' ,'0')
set @sku=@sku + 1
end
declare @sku int
set @sku = 60
while @sku <99
begin
set @strsku='0000000000000' + cast(@sku + 1 as char(39))
insert into dbo.syohinM
values( @str,'001' ,'BREAKFAST SET 2 WITH SOFT DRINK' ,100 ,200 ,0 ,0 ,'0' ,'0' ,'0' ,'0' ,'0' ,'0')
set @sku=@sku + 1
end