declare @ERR int;
insert into T_SpotPicInfo(SpotId,PicPath,smallPicPath,Description,AddUser)values( 1,'s','s','s',2);
select @ERR=@ERR+@@ERROR;--set @ERR=@ERR+@@ERROR;
insert into T_SpotPicInfo(SpotId,PicPath,smallPicPath,Description,AddUser)values( 1,'s','s','s',2);
select @ERR=@ERR+@@ERROR;--set @ERR=@ERR+@@ERROR;
SELECT @ERR
怎么@ERR为NULL
@ERR 没有初值吧
SQL code:
declare @ERR int;
set @ERR=0
insert into T_SpotPicInfo(SpotId,PicPath,smallPicPath,[Description],AddUser)values( 1,'s','s','s',2);
select @ERR=@ERR+@@ERROR; --或者select @ERR=isnull(@ERR+@@ERROR，0)
insert into T_SpotPicInfo(SpotId,PicPath,smallPicPath,[Description],AddUser)values( 1,'s','s','s',2);
select @ERR=@ERR+@@ERROR;
SELECT @ERR
null+值=null
SQL code:
declare @ERR int
set @ERR=0
没有设置初值，ISNULL(@ERR,0)
