In this video, we will learn SQL Server Triggers in a very simple and practical way.
Topics covered in this video:
✔️ What is a Trigger in SQL Server
✔️ Types of Triggers
✔️ AFTER INSERT Trigger
✔️ How Triggers Work
✔️ Real-Time Employee Logging Example
✔️ Capturing Date & Time Automatically using GETDATE()
✔️ Using inserted Table in SQL Server Trigger
We will create:
Employee Table
Employee_Log Table
AFTER INSERT Trigger
Whenever a new employee is added, the trigger will automatically store employee details along with the current date and time in the log table.
This video is perfect for:
Beginners learning SQL Server
Students preparing for interviews
Developers wanting practical trigger examples
Sql scripts
CREATE TABLE [dbo].[Employees](
[EmployeeID] [int] NULL,
[EmployeeName] [varchar](50) NULL,
[Salary] [int] NULL
)
create table Empl_audit_log (EmployeeID int, Createddate datetime);
Insert into Employees VALUES (1,'Avinash',35000)
Create trigger emp_audit_log
on Employees
after insert
as
begin
Insert into Empl_audit_log (EmployeeID,Createddate)
Select EmployeeID,GETDATE() from inserted
end
#SQLServer #SQLTriggers #Database #SQLTutorial #AfterTrigger #SQLForBeginners #DBMS #EmployeeLog
