Error handling in sql server Part 56

[@justinli19901027]

your videos are so good that i'm watching all the ads lol thank you for the awesome tutorials!

[@krzysztofs8535]

Awesome! My greatest admiration! You are great teacher ! I am on this 56 of 135 videos, and i'm goin on and on...

[@saadrouane6521]

Thanks! easier way to learn the concept of try and catch error handling! good job

[@Tarikffm79]

kudvenkat you are the best Teacher on KZbin! I like all your Videos and i have learned a lot! Thank you!

[@jhredcap4303]

Excellent! Extremely well done! Thank you VERY much!

[@Csharp-video-tutorialsBlogspot]

Hi Selvakumar, they are different videos. In Part 55, we discuss about error handling in sql server 2000. In Part 56, we discuss about error handling in sql server 2005 and later versions.

[@pasito287]

verry useful videos till now

[@galleeandfarel]

Great video....superb explanations.....keep up your works......

[@Антон-щ1л7с]

Thank you, your videos is very interestng.

[@mandarchichkar456]

Hi Venkat The way you explain any part is awesome.. Thanks for this. I have one doubt in this session. Can we use this Try.. Catch block in Cursor?? I meas if any error in Cursor value it should throw Error in Catch block and after that cursor continue with rest of values.. I will be glad if you answer my question. Thanks once again

[@shashikantdwivedi298]

Outstanding videos

[@nishaanramphal5166]

very informative , thanks

[@murmles]

Super helpful, thanks!

[@amnahuda7120]

Hello, Very helpful Video series..... Is it possible for U to add video on Dynamic SQL and SQL Injection? Very grateful to U....

[@affaniftikhar4379]

Awesome work...!!!

[@kiranmadari9718]

nice

[@mahmoudyasein3346]

Awesome work.

[@mohsenansari1324]

Hi Venkat, huge respect for you effort , If productSalesID column was an identity column we didn't have to calculate the @Max right ?

[@shrutijha7573]

yes i guess so too

[@VinodKumar-bf6vv]

Thanks for this video session

[@pcdispatch]

There is a big mistake in the video. At 9:47 there is one row affected because the transaction is still active (@@trancount = 1). The transaction needs to be commited or rolled back. Your explanation is true when the commit is executed, but it wasn't.

[@TheBitles]

Thanks!

[@emilywagner6858]

In 2000, you use the @@error and try/catch in 2005 or later, like your videos indicate. Can you still use @@error in 2005 or later as an alternative to try/catch?

[@35035ahmed]

thanks my Dear So much for your great job , but can you help me re to sql server Part 56 if i want to make transaction for many items in the same time and if any items there is not enough amount rollback all the transaction appreciated your reply

[@Gaddy199]

Thanks , this helps

[@stutitehri993]

very important video

[@Vij2011]

gud and nice.

[@richardarmstrong-finnerty3140]

Could also use SELECT @MaxProductSalesId = COALESCE(MAX(ProductSalesId), 0) FROM tblProductSales

Exactly! Or just add an Identity to the ProductSalesId attribute when creating the table, or on alter, but I know he did this for the sake of the demonstration.

[@justblue4864]

Why is the transaction not rolled back automatically when executing the stored procedure without adding the try/catch block, just with BEGIN TRANSACTION and END TRANSACTION?

[@rajani5633]

hi..good work..if possible add vedios for sql profiler..

[@steveearle9678]

Is there a reason you are not using an identity column as your primary key on tblProductSales? It is generating a lot of code to get the current max value.

[@carvajalcr]

Excelente

[@rajanikalyanapu1404]

hi venkat,could you please add vedios for stored procedure with muntiple statements like insert,update and select in single storedprocedure

[@srividya6263]

HI, we love all these playlists,a doubt:cannot we have identity col inside these while inserting , y r we incrementing?

[@ashishchinna9201]

He incremented it purposefully for the demonstration of TRY/CATCH. He comments out that statement to show us how it works.

[@SuperGojeto]

Wow i was just wondering if SSMS has line numbers and not! It feels like an Easter Egg!

[@margam99]

Hi Venkat, can you upload a video on what happens when a SQL query is executed how SQL engine performs all the actions in background

[@Csharp-video-tutorialsBlogspot]

+ranjith kumar Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. At the moment, we don't have videos on the concepts you mentioned. I will record and upload as soon as I can. Thank you very much for your patience. Dot Net & SQL Server training videos for web developers kzbin.infoplaylists?view=1&sort=dd You can order DVDs for offline viewing using the link below www.pragimtech.com/Order.aspx Code Samples & Slides are on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our channel kzbin.info/www/bejne/r2ibYYCtnb5qZtU To receive email alerts, when new videos are uploaded, please subscribe to our channel kzbin.info Please click that THUMBS UP button below the video, if you like the videos Thanks a million for sharing these resources with your friends Best Venkat

[@MadhuKumarBenne]

Hi can you upload a video on concurrency in sql server.

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@abhinaya6932]

Instead of using max(productsales) every time we insert a new row, why not we set the column as identity column, so that next number is automatically generated every time we insert a new row. Please correct me if I am wrong.

[@belugaaa6649]

Because he wants to throw an error and this is the easy way to get PK violation and apt for explaining this concept . in production code , we never do like this . hope it helps :)

[@gatlarajesh3588]

sir can you teach us how db is connected to programming language application

[@sandeepkumar-rk7sc]

Any explain about state in raiseerror

[@manmohansingh6233]

i wanna ask a question are you available to answer

[@DharmendraKrGupta-ts8lj]

Begin Try insert into Try_catch_emp values(001,'Rajeev','Mumbai') End Try Begin Catch select ERROR_MESSAGE() select 1/0 - how to handle this error plz tell me end catch

[@sureshrajput5794]

Sir Half of the part is repeated from previous video this consumes more time to watch and we also dont know where the part will be repeated.

[@brbselvakumar]

part-55 and part-56 are same videos...... can u provide part-56 video......

[@cartoonator4670]

very cheap teaching.