78 How to do error handling in stored procedure sql server

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 ม.ค. 2025

ความคิดเห็น • 13

  • @Mahmoudalgindy
    @Mahmoudalgindy 10 หลายเดือนก่อน

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

    • @learnssis
      @learnssis  10 หลายเดือนก่อน

      Ramadan Mubarak to you as well.

  • @sureshareti2843
    @sureshareti2843 10 หลายเดือนก่อน +1

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

    • @learnssis
      @learnssis  10 หลายเดือนก่อน

      Yeah I will create videos on performance improvement as well.

  • @KranthiPasupuleti-u6i
    @KranthiPasupuleti-u6i 7 หลายเดือนก่อน

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

    • @learnssis
      @learnssis  7 หลายเดือนก่อน

      Thank you. Keep watching 😀

  • @RahamanShaik-m7w
    @RahamanShaik-m7w 10 หลายเดือนก่อน

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

    • @learnssis
      @learnssis  10 หลายเดือนก่อน

      yeah this is in my to do list.

  • @potharlankalakshmaiah2141
    @potharlankalakshmaiah2141 8 หลายเดือนก่อน

    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
      @learnssis  8 หลายเดือนก่อน

      Enable line number in sql server management studio and then you can see the line numbers there
      th-cam.com/video/yE9rnYep9pg/w-d-xo.html

  • @kt-qg7uv
    @kt-qg7uv 10 หลายเดือนก่อน

    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
      @learnssis  10 หลายเดือนก่อน

      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
      @kt-qg7uv 10 หลายเดือนก่อน

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