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  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

Explain about integration services of Microsoft SQL server?

0 Answers  

---

What is Deadlock?

4 Answers   Satyam,

---

How to create a trigger for insert only?

0 Answers  

---

What is a Join in SQL Server?

3 Answers  

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

what does the automatic recovery do? : Sql server administration

0 Answers  

---

What is collation?

0 Answers  

---

What is transaction server implicit?

0 Answers  

---