What is sql server profiler trace data file?

0 Answers  

---

Explain how to send email from sql database?

0 Answers  

---

What are user defined datatypes and when you should go for them?

1 Answers  

---

What are xml indexes?

0 Answers  

---

what is sql injection?

2 Answers  

---

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

Display a roll having miminum marks in two subjects?

7 Answers   Patni,

---

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

---

State the difference between local and global temporary tables?

0 Answers  

---

What is a synonym for manipulation?

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  

---

What is store procedure? How do they work? When do you use?

0 Answers  

---