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.

Posted By -	Karan Gupta

Posted On -	Thursday, June 18, 2015

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**