Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between after trigger and
instead trigger.
- 2 Answers
- 19796 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
Write a sql query to display the current date?
What is a coalesce function?
Where cross join is used?
How many types of keys are there?
Can you explain the disadvantages/limitation of the cursor?
How do I run a trace in sql server?
What is normalization according to you and explain its different levels?
What is the maximum size of a row in sql server?
What is triggers and stored procedures?
what protocol both networks use? : Sql server database administration
What is meant by indexing?
Do you know what is blocking?
Explain aggregate functions?
How to find the login name linked to a given user name?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
