What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

Define primary key?

0 Answers  

---

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

What is bulkcopy in sql?

0 Answers  

---

how many type of indexing in database?

0 Answers   IBM,

---

What to perform pattern match with the like operator?

0 Answers  

---

What is intellisense?

0 Answers  

---

What is Extended user-defined?

0 Answers  

---

What is partitioned view?

0 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  

---