Articles → SQL SERVER → Insert data in view in SQL server

Insert data in view in SQL server






Creating table





Click to Enlarge


Create a view




create view vw_Employee
As
Select EmployeeName, [Description]
From Employee E inner join Designation D
On E.Designation = D.[Description]



Create an Instead of trigger


CREATE TRIGGER TRG_EMPLOYEE_DESIGNATION ON vw_Employee
INSTEAD OF INSERT
AS
BEGIN
    Insert into Employee (EmployeeName)
   select EmployeeName From Inserted 
   
   Insert into Designation 
   select [Description] From Inserted
END



Insert data into view




insert into vw_Employee values('Gyan','Manager')



Output





Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Thursday, June 18, 2015

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250