78 How to do error handling in stored procedure sql server

How to do error handling in stored procedure sql server
Download the scripts used in the video from here: drive.google.com/drive/folder...
SQL Server tutorials: • SQL tutorial for begin...
SQL Server Developer Interview questions: • Sql server developer i...
How to do error handling in stored procedure sql server
How do you handle errors in stored procedures?
How do you handle exceptions in a procedure?
Exception Handling in SQL Server
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@user-iq5hv4fy2r]

good &great...keep rocking for more....

[@learnssis]

Thank you. Keep watching 😀

[@Mahmoudalgindy]

Thanks so much brother Aqil, Ramadan Mubarak 🌙 to you and all of your family.
Appreciated your efforts ❤

[@learnssis]

Ramadan Mubarak to you as well.

[@sureshareti2843]

Thank you bro nice video.... Could u please do one video how to improve stored procedure performance

[@learnssis]

Yeah I will create videos on performance improvement as well.

[@user-mo5qj1sl9d]

Hi Aqil Could you do video on performance tuning because of performance tuning is most important topic in sql server.

[@learnssis]

yeah this is in my to do list.

[@potharlankalakshmaiah2141]

How to find error line in the stored procedure
For example the error line 7 in above video
Where we can see and fix it

[@learnssis]

Enable line number in sql server management studio and then you can see the line numbers there
ua-cam.com/video/yE9rnYep9pg/v-deo.html

[@kt-qg7uv]

Hello sir, I am attending interviews can you please help me in answering the project explanation as an experienced candidate Ive emailed you project please help me . Please respond It will help me a lot

[@learnssis]

I have went through your email. You already have mentioned a project, so be confident and explain it in the interview. Don't go in much detail, just explain in summary form and then tell I have written ssis packages to migrate the data in the project. if they ask about the source of the data then you can pick any format like you can say that the data comes in csv format and then can ask about the size of data then according to the project you can tell how much is the data like in Millions or sometime in the project. be confident while telling. If some data is coming on regular basis in your project then you can say that we have created some incremental load packages to process the daily data, weekly data etc. They are not going to come to your office to check it, so just be confident and explain your activity in the project like, creating tables, creating stored procedures, creating functions, creating ssis packages etc.

[@kt-qg7uv]

@@learnssis Thank you so much I will do it thank you much