Answer Posted / 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

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1327

---

Explain what is the difference between union and union all?

1010

---

What is an execution plan? When would you use it?

980

---

What is it’s similarity with sql server?

160

---

what is checksum in sql server.........???

1686

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

145

---

Explain isolation levels that sql server supports?

1040

---

What is a sql join?

1022

---

How to download microsoft sql server 2005 express edition?

1047

---

what method you can use to reduce the overhead of Reporting Services data sources?

255

---

What are subqueries in sql server?

1123

---

What are drillthrough reports?

155

---

Describe and explain about SQL native client?

1109

---

What do mean by xml datatype?

1104

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

---