Answer / durga prasad

After Trigger fires an operation after any
insert,update,delete operations performed on a table.

Instead Of Trigger fires an operation instead of performing
user specified operation.

u can create instead of trigger on views but u can not
create after triggers on views

Answer / rajneesh hajela

ALTER VIEW Employee AS
SELECT P.SSN as SSN FROM Person P, EmployeeTable E
WHERE P.SSN = E.SSN



CREATE TRIGGER IO_Trig_INS_Employee ON Employee
INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON
-- Check for duplicate Person. If there is no duplicate, do
an insert.
IF (NOT EXISTS (SELECT P.SSN
FROM Person P, inserted I
WHERE P.SSN = I.SSN))
INSERT INTO Person
SELECT SSN,Name,Address,Birthdate
FROM inserted
ELSE
-- Log an attempt to insert duplicate Person row in
PersonDuplicates table.
INSERT INTO PersonDuplicates
```````````````````````````````



FROM inserted
-- Check for duplicate Employee. If no there is duplicate,
do an INSERT.
IF (NOT EXISTS (SELECT E.SSN
FROM EmployeeTable E, inserted
WHERE E.SSN = inserted.SSN))
INSERT INTO EmployeeTable
SELECT EmployeeID,SSN, Department, Salary
FROM inserted
ELSE
--If there is a duplicate, change to UPDATE so that there
will not
--be a duplicate key violation error.
UPDATE EmployeeTable
SET EmployeeID = I.EmployeeID,
Department = I.Department,
Salary = I.Salary
FROM EmployeeTable E, inserted I
WHERE E.SSN = I.SSN
END


syntex can be wrong u see only logic


Instead Of Trigger fires an operation instead of performing
user specified operation.

u can create instead of trigger on views but u can not
create after triggers on views

Rajneesh Hajela

What is indexing and its types?

0 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

What do you understand by a stored procedure?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---