WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

how to dispaly a particular row details from a given table

2 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

Define a cross join?

0 Answers  

---

What are the steps to process a single select statement?

0 Answers  

---

What language is sql server written in?

0 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

---