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 identity?

0 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

What are the types of constraints?

1 Answers  

---

What are translations and its use? : sql server analysis services, ssas

0 Answers  

---

What is an index in a database?

0 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

What is the default order of an order by clause?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

---