27,579
社区成员
发帖
与我相关
我的任务
分享
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE ReturnEffectRows
@selfid int
AS
BEGIN
SET NOCOUNT OFF;
declare @num int
Update tableName SET columnName=Value
where selfid=@selfid
if @@rowcount>0
set @num=@@rowcount;
else
set @num=-1;
return @num;
END
1 select * from bggl_bzjcb
2 print @@rowcount
3 print @@rowcount
4 print @@rowcount
select * from bggl_bzjcb
print @@rowcount
select @@rowcount
print @@rowcount
declare @num int
select * from bggl_bzjcb
if @@rowcount>0
set @num=@@rowcount;
else
set @num=-1;
print @num
select * from bggl_bzjcb
while @@rowcount>0
print @@rowcount;