ALTER PROCEDURE jiang
@ID int,
@jingjin int
AS
declare @a int
declare @number varchar(50)
declare @ka_number varchar(50)
set @number=@ID
set @a=1
while @a<=5
begininsert into jiangjine (ka_number,yingde) values (@number,@jingjin)
set @a=@a+1 end
怎么在里面写事务让错误的时候回滚数据,还有为什么set @number=@ID不能把值传过去,怎么才能传过去?
@ID int,
@jingjin int
AS
declare @a int
declare @number varchar(50)
declare @ka_number varchar(50)
set @number=@ID
set @a=1
while @a<=5
begininsert into jiangjine (ka_number,yingde) values (@number,@jingjin)
set @a=@a+1 end
怎么在里面写事务让错误的时候回滚数据,还有为什么set @number=@ID不能把值传过去,怎么才能传过去?
@ID int,
@jingjin int
AS
declare @a int
declare @number varchar(50)
declare @ka_number varchar(50)
set @number=@ID
set @a=1
while @a<=5
begin
BEGIN TRANSACTION
insert into jiangjine (ka_number,yingde) values (@number,@jingjin)
IF (@@error <> 0)
ROLLBACK TRANSACTION
else
COMMIT TRANSACTION
set @a=@a+1 end
这么写为什么不能赋值过去??
这么写为什么不能赋值过去??
这个传值 这个为什么不能传???