SCOPE_IDENTITY() vs @@IDENTITY in SQL Server | Trigger Example Explained
Learn the difference between @@IDENTITY and SCOPE_IDENTITY() in SQL Server with a real trigger example. In this video, we create an AFTER INSERT trigger on the Employees table and understand how identity values behave when inserting records into log tables. Perfect for SQL Server beginners and interview preparation.
Topics Covered:
✔ @@IDENTITY in SQL Server
✔ SCOPE_IDENTITY() Explained
✔ SQL Trigger Example
✔ AFTER INSERT Trigger
✔ inserted Table in Trigger
✔ Employee Log Example
✔ SQL Interview Questions
Select @@IDENTITY
Select SCOPE_IDENTITY()
Select * From Employees
Select * From EmployeeLogs
INSERT INto Employees (NAME,Salary)
VALUES('Johnson',50000)
Select @@IDENTITY
Select SCOPE_IDENTITY()
CREATE TRIGGER TR_EMPLOG
ON EMPLOYEES
AFTER INSERT
AS
BEGIN
INSERT INTO EmployeeLogs
SELECT EmployeeID,Name,Salary
FROM inserted
END
INSERT INto Employees (NAME,Salary)
VALUES('Johnson 1',50000)
Select @@IDENTITY
Select SCOPE_IDENTITY()
#SQLServer #SQL #SQLTutorial #Database #TSQL #SQLInterviewQuestions #SQLTrigger #DotNet #DBA #LearnSQL #Coding #Programming #SQLShorts #SCOPEIDENTITY #DatabaseDeveloper
On this page of the site you can watch the video online SCOPE_IDENTITY() vs @@IDENTITY in SQL Server | Trigger Example Explained with a duration of hours minute second in good quality, which was uploaded by the user Database King 23 May 2026, share the link with friends and acquaintances, this video has already been watched 25 times on youtube and it was liked by 5 viewers. Enjoy your viewing!
