Your videos on sql have been really helpful. I try and hit the like button on every one of the videos that I find helpful. If you don’t mind me asking, what application do you use to record your screen and make these videos?
hi venkat, instead of passing string in id, if we pass int like 7 or 8 which is not in the table, its still updating the correct id and making the transaction to commit. is there any way to rollback when we pass wrong int? instead of str
Vicky Kumawat Sure, I will record and upload as soon as I can. Thank you very much for your patience. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you th-cam.com/users/kudvenkatplaylists?view=1&sort=dd Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. th-cam.com/video/y780MwhY70s/w-d-xo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. th-cam.com/users/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
I have one question How do we clear Cookies and IE caching in the asp.net application. In which page should we include the code (like login page or master page or log out page )
Hi Venkat, Thanks for your tutorial. I have used wrong ID number but the transaction is not rolled back. I think it's big problem. My table doesn't have ID number 20. can you check the issue and let me know. First transaction is updated but second transaction is not updated. BEGIN TRY BEGIN TRANSACTION UPDATE Accounts SET Balance = Balance - 100 WHERE Id = 1 UPDATE Accounts SET Balance = Balance + 100 WHERE Id = 20 COMMIT TRANSACTION PRINT 'Transaction Committed' END TRY BEGIN CATCH ROLLBACK TRANSACTION PRINT 'Transaction Rolled back' END CATCH I got below output (1 row affected) (0 rows affected) Transaction Committed ---My Table has only 4 records insert into Accounts values (1,'Mark',1000), (2,'Mary',1000), (3,'John',2000), (4,'David',2500)
Here is the link to Part 71 th-cam.com/video/5ZEchu2WnD4/w-d-xo.html You can find all our SQL server videos in a sequence at the following link. Hope this helps. th-cam.com/play/PL08903FB7ACA1C2FB.html
Thank you for teaching us Venkat and 'have a great day' !
Although I am using Oracle DBMS at university, your videos have helped me a lot with some SQL concepts. Thanks
Hi Venkat ,
Yours videos are really helpful .I would suggest you to also upload the videos for SSIS which would make us easy to understand.
Good job mate.
Thanks for your knowledge sharing.. thanks a lot.
hey venkat,am really enjoying your whole video tutorial,please upload AngularJs tutorial as soon as possible..thankyou
harish nayal Hi Harish, Thank you for the feedback. Sure, I will as soon as I can.
you are great man
Hi Venkat, we watch all your .net and sql recordings from sydney. They are Great. Will u be doing full stack recordings as well ?
We want more advance level video on SQL Server.Thanks in advance.
Your videos on sql have been really helpful. I try and hit the like button on every one of the videos that I find helpful. If you don’t mind me asking, what application do you use to record your screen and make these videos?
Hi Venkat, Thank you so much for all these tutorials....Can you please upload Oracle Tutorials if it is possible!! Thanks in advance :)
Thanks Venkat...Any plan videos on AngularJS?
We wish you continue the advance level tutorial on sql server.
hi venkat,
instead of passing string in id, if we pass int like 7 or 8 which is not in the table, its still updating the correct id and making the transaction to commit. is there any way to rollback when we pass wrong int? instead of str
The transaction block would solve a number of bugs in video games where duplication of items becomes possible due to game or server lag.
hey venkat please make a video on backup/restore and attach/Deattach process
Vicky Kumawat Sure, I will record and upload as soon as I can. Thank you very much for your patience.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
th-cam.com/users/kudvenkatplaylists?view=1&sort=dd
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
th-cam.com/video/y780MwhY70s/w-d-xo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
th-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Ya sure I will definitely spread your words
I have one question How do we clear Cookies and IE caching in the asp.net application. In which page should we include the code (like login page or master page or log out page )
*****
Good question
I think we need a video
when we update a balance ,in which the id is integer but not present in the accounts table then it adds the 100$ to id=1 but doest subtract from id= 2
❤️
is it non serial or serial statement?
Thanks
how can i achieve multiple stored procedures in a single transaction sql server.
Hi Venkat, Thanks for your tutorial. I have used wrong ID number but the transaction is not rolled back. I think it's big problem. My table doesn't have ID number 20. can you check the issue and let me know. First transaction is updated but second transaction is not updated.
BEGIN TRY
BEGIN TRANSACTION
UPDATE Accounts SET Balance = Balance - 100 WHERE Id = 1
UPDATE Accounts SET Balance = Balance + 100 WHERE Id = 20
COMMIT TRANSACTION
PRINT 'Transaction Committed'
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
PRINT 'Transaction Rolled back'
END CATCH
I got below output
(1 row affected)
(0 rows affected)
Transaction Committed
---My Table has only 4 records
insert into Accounts values
(1,'Mark',1000),
(2,'Mary',1000),
(3,'John',2000),
(4,'David',2500)
Difference between IList and List in C#
link to next video please
Here is the link to Part 71
th-cam.com/video/5ZEchu2WnD4/w-d-xo.html
You can find all our SQL server videos in a sequence at the following link. Hope this helps.
th-cam.com/play/PL08903FB7ACA1C2FB.html
show me the code! do you really think that propgrammers like to watch videos?
Hi Venkat ,
Yours videos are really helpful .I would suggest you to also upload the videos for SSIS which would make us easy to understand.