Hamed Zakery Miab comments

Results 8 comments of


                                            Hamed Zakery Miab

[Intervention] Ignored attempt to cancel a touchstart event with cancelable=false, for example because scrolling is in progress and cannot be interrupted.

It looks like a working small change, any chance to merge a PR for this?

Create one StoredProcedure for SQL Try-Catchs

یاشا کیشی -----Original Message----- From: "Behzad Khosravifar" [email protected] Sent: ‎5/‎15/‎2015 10:55 AM To: "Behzadkhosravifar/ErrorControlSystem" [email protected] Subject: [ErrorControlSystem] Create one StoredProcedure for SQL Try-Catchs(#54) When us want to run a SP,...

Create one StoredProcedure for SQL Try-Catchs

as an aside, How can I send my custom `Data` to `sp_CatchError`? I Mean is there any way to pass data into `sp_CatchError`? UPDATE: There are two capability I suggest:...

Create one StoredProcedure for SQL Try-Catchs

Thanks a lot :+1: What about the second one? `ID` of inserted row?

Create one StoredProcedure for SQL Try-Catchs

Thank you :) As an offer you can use `OUTPUT INSERTED.ErrorId INTO @OutTable` right after insert column names. while `@OutTable` is defined as below: ``` DECLARE @OutTable TABLE (ErrorId BIGINT)...

Create one StoredProcedure for SQL Try-Catchs

If you mean using `SELECT` statement in SP's body, SQL Server will write the result directly into output context thus developers couldn't catch the value! Using an output parameter let's...

Create one StoredProcedure for SQL Try-Catchs

Actually there are some limitations on scalar function, like Its IMPOSSIBLE to Insert into table in a scalar function.

Create one StoredProcedure for SQL Try-Catchs

thank you Behzad, as we talked before, it's impossible to access local functions like `ERROR_MESSAGE()` from a linked server to handle SQL errors data. please add some inputs to the...