请帮我看看这段Transact-sql数据库代码

来源:百度知道 编辑:UC知道 时间:2024/06/20 23:39:58
declare @n1 int
declare @n2 int
declare @n3 int
declare @n4 int
declare @n5 int
declare @n6 int
declare @m int
declare @n int
declare @p int
set @m=1
set @n=1
set @p=1
set @n1=1
set @n2=5
set @n3=10
while (@n1<=4)
begin
while (@n2<=9)
begin
while (@n3<=15)
begin
while (@n4<=16)
begin
set @n4=@n3+@m
while (@n5<=17)
begin
set @n5=@n4+@n
while (@n6<=18)
begin
set @n6=@n5+@p
insert into fx
values( @n1,@n2,@n3,@n4,@n5,@n6,0,0,0)
set @p=@p+1
end
set @n=@n+1
end
set @m=@m+1
end

insert into fx
values( @n1,@n2,@n3,@n4,@n5,@n6,0,0,0)

改成

insert into fx(字段1,字段2,....字段N)
values( @n1,@n2,@n3,@n4,@n5,@n6,0,0,0)
字段必须与Values里的匹配~`顺序也要匹配

============================

你在查询分析器里执行的吗?
应该执行以下代码:
exec 存储过程名