Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

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 test subquery results with the exists operator?

0 Answers  

---

Is null in sql server?

0 Answers  

---

What is the difference between inner join and equi join?

0 Answers  

---

---

How to create user defined functions with parameters?

0 Answers  

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

How to make a column nullable?

0 Answers  

---

What happens when converting big values to numeric data types?

0 Answers  

---

what is procedure in sql?

2 Answers   Millennium, SQL,

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

What do you think of this implementation? Can this be implemented better?

0 Answers  

---