请大家帮忙看看什么出错的
ALTER PROCEDURE [dbo].[ZK_QOperater_AddInfoByPlan]
@total int
as
Begin
declare @t int
declare @n int
select @t= count(*) from ZK_Quality_Operate
set @n=0
while @n<@total

begin

set @t=@t+1
Insert into ZK_Quality_Operate (QCode) Values ('ZL'+right(100000+rtrim(@t),4),
set @n=@n+1
end

[解决办法]
ALTER PROCEDURE [dbo].[ZK_QOperater_AddInfoByPlan]
@total int
as
Begin
declare @t int
declare @n int
select @t= count(*) from ZK_Quality_Operate
set @n=0
while @n<@total

begin

set @t=@t+1
Insert into ZK_Quality_Operate (QCode) Values ('ZL'+right('100000'+rtrim(@t),4),这里多了个逗号
set @n=@n+1
end
这里还少一个end

下次写begin end 的时候记得先配对，不然嵌套太多了会忘记，没事就结贴