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.
Thank you so Much Venkat for taking the time and providing the videos for us...we trully appreciate it... the explanation and examples are one of a kind on youtube...again thanks again buddy!!!
Thank you so much for your time you spend on the videos. They are very helpful. Actually I am looking for a sql trigger where we can do both instead update and instead delete on a particular column. Is it possible for you to make a video on that?
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ruclips.net/user/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/order.aspx 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. ruclips.net/video/y780MwhY70s/видео.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ruclips.net/user/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. Good Luck Venkat
Hi @kudvenkat .. i have one doubt , while updating the tblemployee , why we are using the employee.id = inserted.id i understand we have to join the employee and inserted table but why id . why not departmentid and similarly inserted.deptid
Thank you for the awesome videos. Could you tell us please how we can make changes in department Name storing in tblDepartment, it means to make the change in tblDepartment "DeptName" columns? Is there any other way to reflect on both base table depends on respective Where clause.For example, My Query isUpdate vWtbleEmployeeDetails Set DepartmentName ='ITR'Where DepartmentName='IT' Could we check the where Clause condition?
That's all right This is update statement (not insert).We changing data about specific person. John made sex-change surgery , changed his/her place of work and now known as Johny
Hi Sir, I don't get why cant the ID be changed from lets say '1' to '10', I have a similar table with EMPNO instead of ID. and when I execute this query Update UPDATE EMP SET EMPNO = 1831 WHERE ENAME='JACK' I am able to update the EMPNO to 1831 from something else. so In this case how do I select the top 1 row based on the EMPNO in the trigger , as the EMPNO itself was changed upon executing an update query?
After providing garbage to DeptName we get a error stating invalid department name. But why is still showing 1 row affected just below the exception. 17:53
Hi Venkat. thanks for all the videos. helping a lot. OK I created Instead of Updated TRIGGER, AND WHEN I AM UPDATING ITS THROWING THIS ERROR: (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) Msg 208, Level 16, State 0, Procedure tr_tblEmployee_ForUpdate1, Line 17 Invalid object name '#temptable'. PLEASE HELP ME TO FIGURE OUT WHATS WRONG WITH THAT.. THANKS ALOT
Why use views to update a database? Surely all the problems you address in this video would not be an issue if you simply update the base tables that the views are sourced from?
we want single resultset and not multiple resultsets that is the reason here we are using join tables to join from multiple tables. By your question if we try to update each base tables then we have to write query for each tables it will be lengthy and there will be multiple result sets.
The examples shown in this channel is not for beginners bcz here the teacher is trying to proove himself. Without reaching in step by step manner with easy small examples..he is putting up lengthy and nonsense undescribed programs..worst channel playing with lives .. I recommend ppl to avoid thiss channel and see same topics somewhere else on RUclips..they are easier and understandable.
I'm now in 2024 .. Your videos only help me to started the carrier in this field...Thanks a lot sir...
Thank you so much sir for these videos..... Really these videos are so helpful and your way of approach is phenomenal
thanlkq very much for helping us ......i have learnt alot from these videos ....instead of learning from institutes its better learn here
I am a excel/database trainer and I really love your videos. They are clear and easy to understand
I am really grateful for your effort making this video, its great and very very useful. Thanks a million
Thank you Venkat for such an in depth session on INSTEAD OF Triggers on Views!!
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.
Thanks Venkat, I greatly appreciate it, the videos you provided to us.
Thank you so Much Venkat for taking the time and providing the videos for us...we trully appreciate it... the explanation and examples are one of a kind on youtube...again thanks again buddy!!!
Your training videoes are very useful. I really like them. Thank you so much!
Vanket you are relly good..Thanks...
Thank you so much for your time you spend on the videos. They are very helpful.
Actually I am looking for a sql trigger where we can do both instead update and instead delete on a particular column.
Is it possible for you to make a video on that?
thanks for all fantastic tutorials well done.
Thanks for this session.
as awesome as always.
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/order.aspx
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.
ruclips.net/video/y780MwhY70s/видео.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ruclips.net/user/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.
Good Luck
Venkat
thank you venkat ..
you are awesome
thank you venkat
good tutorial
Hi @kudvenkat ..
i have one doubt , while updating the tblemployee , why we are using the employee.id = inserted.id
i understand we have to join the employee and inserted table but why id . why not departmentid and similarly inserted.deptid
We should always join using primary key
Thank you for the awesome videos.
Could you tell us please how we can make changes in department Name storing in tblDepartment, it means to make the change in tblDepartment "DeptName" columns? Is there any other way to reflect on both base table depends on respective Where clause.For example, My Query isUpdate vWtbleEmployeeDetails Set DepartmentName ='ITR'Where DepartmentName='IT'
Could we check the where Clause condition?
If we want to update something we can do it directly in table itself y to update here in views I did not get that....If m missing something....
Who would name his daughter Johny?! Sick fella lol
That's all right
This is update statement (not insert).We changing data about specific person.
John made sex-change surgery , changed his/her place of work and now known as Johny
sir, how many triggers can be created on single table, please tell me
+Y Sudhakar stackoverflow.com/questions/14551122/how-many-triggers-can-be-created-on-a-table-in-sql-server
Hi Sir,
I don't get why cant the ID be changed from lets say '1' to '10', I have a similar table with EMPNO instead of ID.
and when I execute this query
Update UPDATE EMP SET EMPNO = 1831 WHERE ENAME='JACK'
I am able to update the EMPNO to 1831 from something else.
so In this case how do I select the top 1 row based on the EMPNO in the trigger , as the EMPNO itself was changed upon executing an update query?
After providing garbage to DeptName we get a error stating invalid department name. But why is still showing 1 row affected just below the exception. 17:53
Hi Venkat. thanks for all the videos. helping a lot.
OK I created Instead of Updated TRIGGER, AND WHEN I AM UPDATING ITS THROWING THIS ERROR:
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
Msg 208, Level 16, State 0, Procedure tr_tblEmployee_ForUpdate1, Line 17
Invalid object name '#temptable'.
PLEASE HELP ME TO FIGURE OUT WHATS WRONG WITH THAT..
THANKS ALOT
trigger is not for temp tables, try it on view.
thanks
Voila
8:45
dying
Hahaha... ya bro listen carefully you will slowllly understand..
Why use views to update a database? Surely all the problems you address in this video would not be an issue if you simply update the base tables that the views are sourced from?
we want single resultset and not multiple resultsets that is the reason here we are using join tables to join from multiple tables. By your question if we try to update each base tables then we have to write query for each tables it will be lengthy and there will be multiple result sets.
Yes my question is, why you are not talking the update statement on views
The examples shown in this channel is not for beginners bcz here the teacher is trying to proove himself.
Without reaching in step by step manner with easy small examples..he is putting up lengthy and nonsense undescribed programs..worst channel playing with lives ..
I recommend ppl to avoid thiss channel and see same topics somewhere else on RUclips..they are easier and understandable.