34,594
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE dbo.delUserAll
as
set nocount on
begin
BEGIN TRANSACTION
Delete from dbo.[userinfo]
IF @@error=0
begin
COMMIT TRANSACTION
SELECT 1
end
ELSE
begin
ROLLBACK TRANSACTION
SELECT 0
end
return
end
GO
create proc dbo.delUserAll
@value int output ----加output表示为返回值
as
。。。