what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

Define cursor locking

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 are the built in functions in sql server?

0 Answers  

---

what is differece between union and union all

6 Answers  

---

What is difference between group by and having?

0 Answers  

---

Explain subquery and state its properties?

0 Answers  

---

What is clustered index

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

Is trigger fired implicitely?

2 Answers  

---