Our Training Programs

All contents are copyright of their authors.

How to use Try and catch blocks using storedprocedure in sql

How to use Try and catch blocks using storedprocedure in sql

Mahesh Babu

8yAsked Aug 21, 2018, 1:07 AM686Learn iOS Programming

Please Help me this

Thanks

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Yogesh Ghorpade8y ago
Accepted answer
CREATE Procedure [SPName]
(
@Para1 numeric=0,
@Para2 varchar(150)

)
As
Begin
BEGIN TRY

--Update Taablename set Para=@Para1,Para2=@Para2
--Delete from Tablename
SELECT
1 AS ErrorNumber
,'Success' AS ErrorMessage;
END TRY
BEGIN CATCH
SELECT
-1 AS ErrorNumber
,'Error In Update' AS ErrorMessage;
END CATCH;
END
Mahesh Babu8y ago
Thanks
Yogesh Ghorpade8y ago
CREATE Procedure [SPName]
(
@Para1 numeric=0,
@Para2 varchar(150)

)
As
Begin
Begin Transaction
INSERT INTO TableName
VALUES (@Para1, @Para2)
IF @@Error <> 0 BEGIN
ROLLBACK TRANSACTION
SELECT
-2 ReurnValue,
' Error while save' AS ErrorMsg,
0 EmpDtlId
RETURN -2
END
COMMIT TRANSACTION
SELECT
1 ReurnValue,
'Success' AS ErrorMsg

RETURN 1
END
Mahesh Babu8y ago
Thanks

Yogesh Ghorpade

How to use insert ,update ,delete in stored procedure can you please show one demo

Thanks
Yogesh Ghorpade8y ago
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-2017