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 the difference between having clause and where clause in sql server?

0 Answers  

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

---

What is the difference between nvl and nvl2?

0 Answers  

---

Differentiate between mongodb vs. Sql server?

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

How to Update from select query in sql server?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

What are policy management terms?

0 Answers  

---

What are the advantages of mirroring?

0 Answers  

---

What is acid db?

0 Answers  

---