DML triggers in sql server Part 43

Very easy to understand still best in 2020

logically there is no way i can use 2 insteqd of trigger, right?

SELECT * from Employees;

SELECT * from Employees_Audit;

CREATE TRIGGER tr_Employees_ForInsert

ON Employees

FOR INSERT

AS

BEGIN

Declare @Id int

Select @Id = Id from inserted

insert into Employees_Audit

values ('New employee with Id = ' + Cast (@Id as NVARCHAR(5) ) + 'is added at' + cast ( Getdate () as NVARCHAR (20)))

END;

I got an error: Column name or number of supplied values does not match table definition. Could please reply. Thanks

Explanations are good but ur energy is low which somehow make bored

Mending belajar dari sini baca modul dosen malah bingung sendiri gafaham

So helpful dude i love you

Life is Amazing..
8 years ago when this video was uploaded i was in grade 9.
i had no idea in future that i will become an programmer…..
and now here i am watching this video that means somewhere between our lives there will be connection to something in which it seems that our life is exceptional ..
Just wow <3

hi sir,
i have one table. it has four column.
after insert data in first two column.
I want to do trigger action
sum w.r.t. column3 where group by column1 and insert into inserted record @ column3
sum w.r.t. column4 where group by column1 & colum2 and insert into inserted record @ column4.
same table ……….not other table………….

Perfect ….. thanks for sharing that . some important info for guys … SQL server support only statement-level trigger mean if u try to make multi delete from table [tblEmployee] by this script
delete from tblEmployee where id in (1,4,6) then ur trigger will only fire once because trigger in sql server is statement-level triggers so be aware if you try to make balances from inserted or deleted rows … solution is avoid multi statement scripts like delete example that we show previously or check inserted or deleted and hold its data inside temp table and loop for that

Create table tblEmployeeAudit
(
Id int identity(1,1),
AuditData nvarchar(100)
)

Alter Trigger tr_tblEmployee_ForInsert
ON tblEmployee
FOR INSERT
AS
BEGIN
Declare @Id int
Select @Id = Id from inserted

Insert into tblEmployeeAudit values ('New Employee With Id = ' + Cast(@Id as nvarchar(5)) + ' is added at '
+ cast(GetDate() as nvarchar(20)))

End

please share the Link of "SQL JOIN" concepts if possible

Thank you for this video and your efforts for all those people specially students, for clearing their concepts…….

please start new series on react js and react native if possible.

At 12:48, I don't understand the purpose of doing ALTER TRIGGER. Also I didn't see ALTER TRIGGER in the DELETE trigger.

Thank you

EXCELLENT JOB, THANKS

Great explanation sir! Thanks for this wonderful video. 🙂

How come Evey thing you teach looks so simple at least as long as I am on video… Best man on internet 👍

I created insert trigger and delete trigger on the same table. If insert trigger is working then delete is not working. Both are not working simultaneously. Please help

thank you, this is really a good tutorial.

Your Videos are highly helpful. Thanks a lot for easy understanding

I love your videos so so so so …….much . Thank you

thnks man i m learning more and more from your videos

excellent tutorial. thanking you.

Thank you for making this video I was having so much trouble understanding DML triggers and your video made it easier to understand

If insert multiple rows at a time, will this trigger still working?? For instance, Insert into tblEmployee values (9, 'Rick', 'Male', 4), (10, 'Jimmy', 'Male', 3)

2nd to none

Auditdata column is nvarchar or date or int?

Thank You so so much for what u are doing for us <3 Your videos are amazing!

Very good explanation, Thankd

i tried lot of times venkat it showing error like "Msg 213, Level 16, State 1, Procedure tr_sample_forinsert2, Line 7

Column name or number of supplied values does not match table definition."please give a solution for this

YOU ARE GENIUS!!!!!!

Thank you so much sir for this best video….. thanks a lot

amazing! thank you so much I have understand really clearly the code with your instruction

What if we use 'select @Id=Id from tblemp' instead of 'select @Id=Id from inserted'? Aren't they identical?

The explanation plus everything is A+ please keep it up

Create Trigger [dbo].[TriggLog]

on [dbo].[DatabaseLog]

for delete, insert

as
begin

declare @id1 int, @id2 int

select @id1 = [DatabaseLogID] from Inserted

select @id2 =[DatabaseLogID] from deleted

insert into [dbo].[tbl_audit] (ID1, id2)

values (@id1, @id2)

end
——————————————————- Depending on whether ID1 for inserted or ID2 for deleted, I make it much easier.
select a.ID1, c.[FirstName]+' '+c.[LastName] as insertedName

from [dbo].[tbl_audit] as a

Left Join [AdventureWorksDW2017].[dbo].[DimCustomer] as c

on a.id1 = c.[CustomerKey]

select a.ID2, c.[FirstName]+' '+c.[LastName] as deletedName

from [dbo].[tbl_audit] as a

Left Join [AdventureWorksDW2017].[dbo].[DimCustomer] as c

on a.id2 = c.[CustomerKey]

I can store more information in Audit Table because Deleted and INSERTED tables are temporary tables.
Thank you Venkat you are amazing

You are such a wonderful teacher, thank you!

Good explanation. Easy to follow. Thank u for this video..

thank you <3

Thank u for ur guideline…Because of ur video i understand Stored Procedure

i'm so greatful thank you so much sir

you are fuxxing amazing!

I have created the Data audit database just like you but I found the error "Column name or number of supplied values does not match table definition"
what kind of audit ID is int and what is DataAudit type ??
so I can not match the table

It's Very HelpFull…….. Explain Very Easy ………..Thank you So Much

hello im souad from algeria i m a new developper in oracle apex so i have a prb to create a trigger for insert and update dates
and this is my script that's i m do it so when i m run this script i have an error means my trigger not valid so please help me and thaink you in advanced
CREATE OR REPLACE TRIGGER "CONVENTION_T1"
BEFORE
insert or update on "CONVENTION"
for each row
begin
declare @DD date
declare @DF date
begin
select @DD=DAT_DEB_CONV from inserted
select @DF=DAT_FIN_CONV from inserted
if @DD>@DF
begin
raiserror('impossible d'insere cette date ',16,1)
rollback tran
end
end;
end;
/
ALTER TRIGGER "CONVENTION_T1" ENABLE;