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  

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

Why do we use stored procedures in sql server?

0 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

What is the usage of sign function?

0 Answers  

---

What is the partitioning method?

0 Answers  

---

How to get @@error and @@rowcount at the same time?

0 Answers  

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What stored by the tempdb ? : sql server database administration

0 Answers  

---