tag:blogger.com,1999:blog-6082652835152798567.post3418662127706503484..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Error handling in sql server 2005, and later versions - Part 56Unknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6082652835152798567.post-61058252557925933792024-01-30T04:49:01.207-08:002024-01-30T04:49:01.207-08:00Even me too Nikhil, KudVenkat helped me to bag man...Even me too Nikhil, KudVenkat helped me to bag many offers in MNC's.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-72436578558394546692021-07-12T04:17:42.149-07:002021-07-12T04:17:42.149-07:00Even I had the same question initially, guess we c...Even I had the same question initially, guess we can do that, here primary key is used just for demonstrating how error can be generated and captured using try catch method.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-80155638989121640882020-04-16T11:55:32.221-07:002020-04-16T11:55:32.221-07:00These videos are helping me in quarantine to learn...These videos are helping me in quarantine to learnNikhilhttps://www.blogger.com/profile/03427718188169638100noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-61736848879977743232019-09-16T23:56:16.138-07:002019-09-16T23:56:16.138-07:00The try block says you write any piece of code ins...The try block says you write any piece of code inside me, if it doesn't work exception will be thrown. Here in the try block, we are saying i want to run a transaction, then try block says Lets BEGIN (please note the transaction has begun) the transaction, if the transaction is not successful, catch block will be called and the transaction will be rollbacked.<br /><br />Hope this helpsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-7968820397857920592019-08-01T00:11:08.585-07:002019-08-01T00:11:08.585-07:00Hi sir,
Thankq for ur exultant video series.Sir ...Hi sir,<br /> Thankq for ur exultant video series.Sir i have 1 doubt if i use identity column on ProductSalesId instead of primary key it will increases the row no automatically.so no need to Declare @MaxProductSalesId int and soooosatyahttps://www.blogger.com/profile/03556671001662175254noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-73510654431806440152018-06-30T04:27:47.484-07:002018-06-30T04:27:47.484-07:00I think begin transaction must be outside the try ...I think begin transaction must be outside the try because in catch rollback statement will throw an error , when transaction is not started... Please suggest...Anonymoushttps://www.blogger.com/profile/18347569571801760273noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-10800176930808530832017-04-03T04:29:34.496-07:002017-04-03T04:29:34.496-07:00thanks my Dear So much for your great job , but ca...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 <br />appreciated your replyAnonymoushttps://www.blogger.com/profile/17653184797366238371noreply@blogger.com