Articles → SQL SERVER → Insert Data In View In SQL Server

Insert Data In View In SQL Server

In this article, I will explain how to insert data into view.

Creating Table

First, create 2 tables i.e., "Employee" and "Designation". See the following figure.

Picture showing the design view of the Employee and Designation tables

Create A View

Create a view using the following "SELECT" statement.

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 data into view using the following statement.

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

Output

Once you run the preceding statement, the value gets inserted not in view but in columns of respective tables. See the following figure.

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Thursday, June 18, 2015

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**