78 How to do error handling in stored procedure sql server

[@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.

[@KranthiPasupuleti-u6i]

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

[@learnssis]

Thank you. Keep watching 😀

[@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.

[@RahamanShaik-m7w]

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 kzbin.info/www/bejne/r3aco6GPmtVspsk

[@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