set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[add_goodcorporate]
as
set nocount on
begin
declare @i int
declare @j int
set @i=1
while @i<=27
begin
while @j<=16
begin
insert into cc_goodcorporate(logo_name,logo_url,logo_img,logo_flg,cat_id,is_show,logo_order,logo_clicks,flg) values('aaa',' http://www.***.com','images/goodcorporate/2011224134221.jpg','0',@i,'1',@j,0,0)
set @j=@j+1
end
set @i=@i+1
end
end我想实现向表中自动添加数据
这个表中的cat_id和logo_order两个字段不一样,其他的都一样不知道这里什么地方出错了,不运行
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[add_goodcorporate]
as
set nocount on
begin
declare @i int
declare @j int
set @i=1
while @i<=27
begin
while @j<=16
begin
insert into cc_goodcorporate(logo_name,logo_url,logo_img,logo_flg,cat_id,is_show,logo_order,logo_clicks,flg) values('aaa',' http://www.***.com','images/goodcorporate/2011224134221.jpg','0',@i,'1',@j,0,0)
set @j=@j+1
end
set @i=@i+1
end
end我想实现向表中自动添加数据
这个表中的cat_id和logo_order两个字段不一样,其他的都一样不知道这里什么地方出错了,不运行
变量没有指定的初始值!
@i @j
set @i = 1
set @j = 1
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[add_goodcorporate]
as
set nocount on
begin
declare @i int
declare @j int
set @i=1
set @j = 1 --@j 没有初始化!
while @i<=27
begin
while @j<=16
begin
insert into cc_goodcorporate(logo_name,logo_url,logo_img,logo_flg,cat_id,is_show,logo_order,logo_clicks,flg) values('aaa',' http://www.***.com','images/goodcorporate/2011224134221.jpg','0',@i,'1',@j,0,0)
set @j=@j+1
end
set @i=@i+1
end
end