Instead of insert trigger Part 45

  Рет қаралды 277,753

kudvenkat

kudvenkat

Күн бұрын

Пікірлер: 67
@sohanyennu3750
@sohanyennu3750 7 жыл бұрын
I really enjoyed this video...very informative
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 7 жыл бұрын
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 kzbin.infoplaylists?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. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info 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
@lazykitten4356
@lazykitten4356 5 жыл бұрын
you are the BEST sql teacher on KZbin> Thank you so much!
@elainemayer8978
@elainemayer8978 11 жыл бұрын
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.
@renganathansrb5032
@renganathansrb5032 7 жыл бұрын
You are awesome, your teaching is very soft and nice. Thanks for ur videos.
@krzysztofs8535
@krzysztofs8535 8 жыл бұрын
very useful videos. i'm going to end the whole course. till now they quality is on the high level
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 11 жыл бұрын
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.
@kaviyarasan3624
@kaviyarasan3624 5 жыл бұрын
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.
@shivaganga9148
@shivaganga9148 2 жыл бұрын
Once we see any video of yours we don't want to repeat it again that simple we can learn
@cassavates
@cassavates 11 жыл бұрын
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
@pramodkumarsura1880
@pramodkumarsura1880 10 жыл бұрын
Hello Venkat, You are awesome, your teaching is very soft and nice. a layman can understand the concept easily.
@hariishr
@hariishr 4 жыл бұрын
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
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 4 жыл бұрын
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.
@sumitbhardwaj2992
@sumitbhardwaj2992 7 жыл бұрын
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
@harishme4726
@harishme4726 4 жыл бұрын
Nice explanation sir hatsoff.. keep on doing more..
@nimeshambalalpatel3032
@nimeshambalalpatel3032 4 жыл бұрын
Great teaching sir!!!
@nishigandhaghadage6350
@nishigandhaghadage6350 4 жыл бұрын
Very useful. Thank You very much!
@sweetysharma2621
@sweetysharma2621 3 жыл бұрын
Intresting one 💕
@devexpost8508
@devexpost8508 7 жыл бұрын
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.
@creedyrn25
@creedyrn25 Жыл бұрын
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
@MukeshKumar-vy6ep
@MukeshKumar-vy6ep 4 жыл бұрын
very useful videos.....Thank you and sir can you upload some of the python videos for begineers
@sapnanayak1453
@sapnanayak1453 2 жыл бұрын
Yes! I want Venkat sir to do a Python series too.
@sayalithakar4526
@sayalithakar4526 7 жыл бұрын
Hi Venkat,very useful video.Please put videos on Datastructures and Algorithm
@richardlah6030
@richardlah6030 10 жыл бұрын
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
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 10 жыл бұрын
Please start with C#, followed by ASP.NET. Good Luck.
@SuperGojeto
@SuperGojeto 9 жыл бұрын
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???
@stutitehri993
@stutitehri993 10 жыл бұрын
god bless you;sir
@Felixantony84
@Felixantony84 10 жыл бұрын
Very useful. Thank you master...
@piyasidey2117
@piyasidey2117 4 жыл бұрын
Thank you very much Sir.
@gkmishra2009
@gkmishra2009 3 жыл бұрын
great tutorial
@henrifanda4784
@henrifanda4784 5 жыл бұрын
very well explained. thx.
@ivvhis9841
@ivvhis9841 4 жыл бұрын
THANK YOU !
@Shankar-zi3yk
@Shankar-zi3yk Жыл бұрын
can we do the same using for insert
@kabeerbindra3061
@kabeerbindra3061 5 жыл бұрын
Thanks 🥰
@hussainmadar4
@hussainmadar4 8 жыл бұрын
+kudvenkat when I create a trigger ,it inserts the columns in inserted but cannot insert it into base tables?
@ChhajedShweta
@ChhajedShweta 8 жыл бұрын
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.
@HibaAlMasri
@HibaAlMasri 4 жыл бұрын
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..
@colombuzz8550
@colombuzz8550 3 жыл бұрын
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!!
@Shivakumar-367
@Shivakumar-367 Жыл бұрын
Is this admin and development cource ???
@MrCshrawankumar
@MrCshrawankumar 10 жыл бұрын
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?
@prabhatKumar-dh6fr
@prabhatKumar-dh6fr 6 жыл бұрын
I think because one row got inserted into special inserted table of triggers.
@cascadeaklilu3343
@cascadeaklilu3343 9 жыл бұрын
hi I got a lot from this and old other lesson. cld u advise me where to star in programing tnx
@Csharp-video-tutorialsBlogspot
@Csharp-video-tutorialsBlogspot 9 жыл бұрын
+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 kzbin.infoplaylists?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. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info 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
@redduck8068
@redduck8068 10 жыл бұрын
Excelent videos
@harshavardhan8018
@harshavardhan8018 7 жыл бұрын
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.
@mocanada304
@mocanada304 2 жыл бұрын
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.
@bextla3737
@bextla3737 8 жыл бұрын
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?
@Mousesenpai
@Mousesenpai 2 жыл бұрын
best in class
@techdurgesh3532
@techdurgesh3532 6 жыл бұрын
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.
@PrdpPtl-j4b
@PrdpPtl-j4b Жыл бұрын
We can use instead of trigger on table and if No than why ¿??
@uhanunipurc
@uhanunipurc Жыл бұрын
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."
@leenadeore1403
@leenadeore1403 4 жыл бұрын
Hi Sir, Why didn't insert value in department table it doesn't exists already?
@cascadeaklilu3343
@cascadeaklilu3343 9 жыл бұрын
thank you sir
@tonyfdd
@tonyfdd 6 жыл бұрын
Hi sir , One small doubt In that trigger why do v need that last line I.e select Id,name,gender,@depid from inserted
@MrMohican1989
@MrMohican1989 5 жыл бұрын
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.
@dharmender1975
@dharmender1975 7 жыл бұрын
please make on partition in sql
@muayas9602
@muayas9602 8 жыл бұрын
Why having "id" column as identity gives me 0 in "select * from inserted".
@nishademperor8695
@nishademperor8695 6 жыл бұрын
sir you could have given an easy example instead of this complicated one
@shabbirali5899
@shabbirali5899 7 жыл бұрын
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
@ungeheurenungeziefer2662
@ungeheurenungeziefer2662 4 жыл бұрын
Important note: it works only with INNER JOIN inside triggers body. I typed LEFT JOIN somewhy and nothing works :)
@mohammadshawn2458
@mohammadshawn2458 8 жыл бұрын
nice
@mostafaabdelnasser8969
@mostafaabdelnasser8969 10 жыл бұрын
you hitting the target soo good
@prafulrane9037
@prafulrane9037 29 күн бұрын
anyone in 2025?
Instead of update triggers in sql server - Part 46.avi
22:27
kudvenkat
Рет қаралды 185 М.
After update trigger   Part 44
17:19
kudvenkat
Рет қаралды 333 М.
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 20 МЛН
Каха и дочка
00:28
К-Media
Рет қаралды 3,4 МЛН
SQL CTEs (Common Table Expressions) - Why and How to Use Them
7:56
Database Star
Рет қаралды 38 М.
DML triggers in sql server   Part 43
17:45
kudvenkat
Рет қаралды 698 М.
Querying 100 Billion Rows using SQL, 7 TB in a single table
9:07
Arpit Agrawal (Elastiq.AI)
Рет қаралды 58 М.
DatePart, DateAdd and DateDiff functions in SQL Server   Part 27
21:29
Clustered vs. Nonclustered Index Structures in SQL Server
8:04
Voluntary DBA
Рет қаралды 671 М.
Scalar user defined functions in sql server   Part 30
19:07
kudvenkat
Рет қаралды 525 М.
SQL Indexes | Clustered vs. Nonclustered Index | #SQL Course #21
43:10