Hello Dear Sohan, 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 ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.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. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-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. Good Luck Venkat
Hi Venkat, let me thank you very much for this thorough and detailed and beginner-friendly training - it is not even on my mother-tongue and still I understand also the complex stuff I thought I might not understand :) Also it teaches how to be structured for SQL thinking, and for my DB-s consistency and unambiguity. Great training, thanks and congratulations, and I wish a lot of success with your work for the future! Sincerely: cassavates
I has started confused on Feb 5 in joining two tables using trigger but I'm not find any resolution for the requirement. But now I find because you was teaching me. Thank you so much.
i like your all video, and thank those friend whose tolled me, watch prazym technology videos your video is too long but u difine many things in detail if any body have no knowledge about programing language your video is very helpful of those people india proud of your Mr. kudvenkat u i am very happy of your work and u give free teach in good quality every one not gud in english so u should one copy of hindi language
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.
Initially difficult to understand this topic (as I'm from non IT background) After watching few times n slowly following steps in the blog understood this , thank you
Hello Harish - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
HI Kudvenkat I am thro with the sql server which was excellent. My interested is heightened in the other 2 courses i.e C# and ASP.Net . Can you advise on the effective order to study these 2. Should it be C# first or Asp.net. Many Thanks Richard
I have a small doubt. Initially when u created the trigger as select * from inserted. Then insert into view statement and execute the statement. But no data gets actually inserted in the view even though the trigger fires. So how is possible that the select * from inserted returns the row that we were trying to insert???
It's a fine example for a tutorial, but note that the trigger assumes the DeptName column is unique, and also that there is only a single row insert being performed.
You just spoke my mind. How would it result if it’s a non-unique column and how could we insert multiple tables at once..These are my thoughts. Hopefully I find these answers in the future
Hi Venket, Thanks for ur videos. I have a small doubt regarding raise error thing. When u tried to insert invalid department name in the view there was an error saying "Invalid Department name. Statement terminated". When nothing is executed after this error, then y we get "1 row(s) affected" msg below the error msg?
Hello sir, can you please suggest best way to insert multiple rows using instead of inert trigger. Example provided in the video works fine when query insert only 1 row at a time. But it failed when I tried inserting multiple rows. I also tried one by using cursor, which worked as expected but adversely hit query performance. Any suggestion will be of great help.
Hi Venkat, While we are trying to check the user supplied DepartId (@DeptId) with the DepartmentId in the table, what is the reason that we are using '=' operator instead of '==' operator. Please clarify.
Hi Kudvenkat, 1st thank you so much for the SQL tutorial. 2nd what if the user enters multiple rows in an insert statement and one of the rows have a wrong department? the variable for department would not be null but there will be a wrong department..
Thats why there is a lookup into department table for junk data( dept name).!! And for multiple insertions we can handle by looping through each record!!
Sir, I have a problem. I want to get the record from TABLE _1 and update the table _2 and the original tbale (TABLE _1) I have no updates and updated record table _2 I get inserted.
Hi. it is useful. when l insert new values to view table, l face with problem that 'Conversion failed when converting the nvarchar value 'IT' to data type int'. How can l fix this?
+Cascade Aklilu 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 ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd The following is the order 1. C# 2. Dot Net Basics 3. SQL Server 4. ADO .NET 5. ASP .NET 6. GridView tutorial 7. MVC 8. WCF 9. Entity Framework 10. LINQ 11. LINQ to XML 12. LINQ to SQL 13. Chart Control 14. JavaScript 15. JavaScript with ASP .NET 16. jQuery 17. AngularJS If you need DVDs for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.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. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-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. Good Luck Venkat
A bit late but you need it because you have retrieved the right ID number from the table where departments are described and stored that value in the @id variable. So now you need to insert the rights values into the first base table which you weren't able to do correctly because you had the 'DepartmentName' and not the department 'Id' when you tried to raw insert the statement as the first base table is ID | NAME | GENDER | DEPARTMENT ID. When you finally insert into the base table you haven't stored the others value anywhere so we need to retrieve them too and use them directly with SELECT ID, NAME, GENDER (till here equals the raw insert beside the Select instead Insert keyword) and @ID (which now holds the ID of the department which we only knew the name on the first try of the insert statement) FROM inserted. I think SQL engine know it will not have to find @ID from table inserted as it is a variable that we already assigned but it will retrieve all other values that are valid for our insert.
I am getting a message when trying to insert a new row: "Msg 544, Level 16, State 1, Procedure tr_vWEemployeeDetails_InsteadOfInsert, Line 23 [Batch Start Line 3] Cannot insert explicit value for identity column in table 'tblEmployee4' when IDENTITY_INSERT is set to OFF."
I m learning SQL very well from yours tutorial :) I have a small doubt e.g you create a int variable and join depname between tables and put these into Int variable Why? plz explain
I really enjoyed this video...very informative
Hello Dear Sohan,
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
ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.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.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-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.
Good Luck
Venkat
you are the BEST sql teacher on UA-cam> Thank you so much!
I've watched over 30 of your sql training videos. They're all very helpful. Thank you so much for taking time to make these videos.
very useful videos. i'm going to end the whole course. till now they quality is on the high level
Hi Venkat, let me thank you very much for this thorough and detailed and beginner-friendly training - it is not even on my mother-tongue and still I understand also the complex stuff I thought I might not understand :) Also it teaches how to be structured for SQL thinking, and for my DB-s consistency and unambiguity. Great training, thanks and congratulations, and I wish a lot of success with your work for the future! Sincerely: cassavates
You are awesome, your teaching is very soft and nice.
Thanks for ur videos.
I has started confused on Feb 5 in joining two tables using trigger but I'm not find any resolution for the requirement. But now I find because you was teaching me. Thank you so much.
Hello Venkat,
You are awesome, your teaching is very soft and nice. a layman can understand the concept easily.
Once we see any video of yours we don't want to repeat it again that simple we can learn
i like your all video, and thank those friend whose tolled me, watch prazym technology videos your video is too long but u difine many things in detail if any body have no knowledge about programing language your video is very helpful of those people india proud of your Mr. kudvenkat u i am very happy of your work and u give free teach in good quality every one not gud in english so u should one copy of hindi language
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.
Initially difficult to understand this topic (as I'm from non IT background)
After watching few times n slowly following steps in the blog understood this , thank you
Hello Harish - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy.
www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
Nice explanation sir hatsoff.. keep on doing more..
Great teaching sir!!!
Very useful. Thank You very much!
Intresting one 💕
Hi Venkat,very useful video.Please put videos on Datastructures and Algorithm
Very useful. Thank you master...
HI Kudvenkat
I am thro with the sql server which was excellent. My interested is heightened in the other 2 courses i.e C# and ASP.Net . Can you advise on the effective order to study these 2. Should it be C# first or Asp.net.
Many Thanks
Richard
Please start with C#, followed by ASP.NET. Good Luck.
very useful videos.....Thank you and sir can you upload some of the python videos for begineers
Yes! I want Venkat sir to do a Python series too.
I have a small doubt. Initially when u created the trigger as select * from inserted.
Then insert into view statement and execute the statement.
But no data gets actually inserted in the view even though the trigger fires.
So how is possible that the select * from inserted returns the row that we were trying to insert???
great tutorial
Thank you very much Sir.
very well explained. thx.
THANK YOU !
It's a fine example for a tutorial, but note that the trigger assumes the DeptName column is unique, and also that there is only a single row insert being performed.
You just spoke my mind. How would it result if it’s a non-unique column and how could we insert multiple tables at once..These are my thoughts.
Hopefully I find these answers in the future
Thanks 🥰
+kudvenkat when I create a trigger ,it inserts the columns in inserted but cannot insert it into base tables?
god bless you;sir
Hi Venket,
Thanks for ur videos.
I have a small doubt regarding raise error thing. When u tried to insert invalid department name in the view there was an error saying "Invalid Department name. Statement terminated". When nothing is executed after this error, then y we get "1 row(s) affected" msg below the error msg?
I think because one row got inserted into special inserted table of triggers.
Hello sir, can you please suggest best way to insert multiple rows using instead of inert trigger.
Example provided in the video works fine when query insert only 1 row at a time.
But it failed when I tried inserting multiple rows. I also tried one by using cursor, which worked as expected but adversely hit query performance. Any suggestion will be of great help.
Hi Venkat,
While we are trying to check the user supplied DepartId (@DeptId) with the DepartmentId in the table, what is the reason that we are using '=' operator instead of '==' operator. Please clarify.
I am pretty sure there is no double equal sign in MS SQL or even MySQL.
You always use single = to compare in MS SQL, as you do in the WHERE clause.
Excelent videos
best in class
Hi Kudvenkat, 1st thank you so much for the SQL tutorial. 2nd what if the user enters multiple rows in an insert statement and one of the rows have a wrong department? the variable for department would not be null but there will be a wrong department..
Thats why there is a lookup into department table for junk data( dept name).!!
And for multiple insertions we can handle by looping through each record!!
Sir, I have a problem. I want to get the record from TABLE _1 and update the table _2 and the original tbale (TABLE _1) I have no updates and updated record table _2 I get inserted.
can we do the same using for insert
thank you sir
Hi. it is useful. when l insert new values to view table, l face with problem that 'Conversion failed when converting the nvarchar value 'IT' to data type int'.
How can l fix this?
Is this admin and development cource ???
hi I got a lot from this and old other lesson. cld u advise me where to star in programing tnx
+Cascade Aklilu 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
ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
The following is the order
1. C#
2. Dot Net Basics
3. SQL Server
4. ADO .NET
5. ASP .NET
6. GridView tutorial
7. MVC
8. WCF
9. Entity Framework
10. LINQ
11. LINQ to XML
12. LINQ to SQL
13. Chart Control
14. JavaScript
15. JavaScript with ASP .NET
16. jQuery
17. AngularJS
If you need DVDs for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.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.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-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.
Good Luck
Venkat
Hi Sir, Why didn't insert value in department table it doesn't exists already?
Why having "id" column as identity gives me 0 in "select * from inserted".
Hi sir ,
One small doubt
In that trigger why do v need that last line I.e select Id,name,gender,@depid from inserted
A bit late but you need it because you have retrieved the right ID number from the table where departments are described and stored that value in the @id variable. So now you need to insert the rights values into the first base table which you weren't able to do correctly because you had the 'DepartmentName' and not the department 'Id' when you tried to raw insert the statement as the first base table is ID | NAME | GENDER | DEPARTMENT ID. When you finally insert into the base table you haven't stored the others value anywhere so we need to retrieve them too and use them directly with SELECT ID, NAME, GENDER (till here equals the raw insert beside the Select instead Insert keyword) and @ID (which now holds the ID of the department which we only knew the name on the first try of the insert statement) FROM inserted. I think SQL engine know it will not have to find @ID from table inserted as it is a variable that we already assigned but it will retrieve all other values that are valid for our insert.
I am getting a message when trying to insert a new row: "Msg 544, Level 16, State 1, Procedure tr_vWEemployeeDetails_InsteadOfInsert, Line 23 [Batch Start Line 3]
Cannot insert explicit value for identity column in table 'tblEmployee4' when IDENTITY_INSERT is set to OFF."
nice
We can use instead of trigger on table and if No than why ¿??
I m learning SQL very well from yours tutorial :) I have a small doubt e.g
you create a int variable and join depname between tables and put these into Int variable
Why? plz explain
please make on partition in sql
you hitting the target soo good
Important note: it works only with INNER JOIN inside triggers body. I typed LEFT JOIN somewhy and nothing works :)
anyone in 2025?
sir you could have given an easy example instead of this complicated one