34,838
社区成员




create procedure test_p
@deviceNumber varchar(64)
as
begin tran
begin try
if @deviceNumber<>''
begin
end
else
begin
end
end try
begin catch
if @@trancount>0
begin
rollback tran
return 0
end
end catch
if @@trancount>0
begin
commit tran
return 1
end
CREATE PROCEDURE test_p @deviceNumber VARCHAR(64)
AS
BEGIN TRAN;
BEGIN TRY
IF @deviceNumber <> ''
BEGIN
PRINT 0; --这里要有内容
END;
ELSE
BEGIN
PRINT 0; --这里要有内容
END;
END TRY
BEGIN CATCH
IF @@trancount > 0 BEGIN
ROLLBACK TRAN;
RETURN 0;
END;
END CATCH;
IF @@trancount > 0 BEGIN
COMMIT TRAN;
RETURN 1;
END;