Error handling in SQL Server | Try Catch Block | RaisError | Throw
Рет қаралды 1,329
Күн бұрын
@AjaySingh-kj6mm 10 ай бұрын
👌👌
@mssqlexpert 10 ай бұрын
Thank you 🙏
@dineshm46 7 ай бұрын
If the try block looks like BEGIN TRY Print 'Hi'; Select 15/0; print 'Hello'; Select 10/0; END TRY the error line display is 3 (Select 15/0;) i need to print the both the error 10/0 also what to do?
@mssqlexpert 7 ай бұрын
this is Runtime error, first you have to resolve first error then sql engine knows second 10/0- divide by zero error. then it will print. BEGIN TRY Print 'Hi' Select 15/0 print 'Hello' Select 10/0 END TRY Begin catch Select ERROR_MESSAGE(),ERROR_NUMBER() End catch not tried yet such scenario, i have to check it. Thanks.
sql expert
Рет қаралды 3,1 М.
sql expert
Рет қаралды 278
sql expert
Рет қаралды 1,8 М.
All about data
Рет қаралды 1,3 М.