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 indexed views and partitioned view with their syntax.

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

Define outer join in sql server joins?

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

What are the benefits of filtered indexes?

0 Answers  

---

What is forward - only cursors / read only cursor?

0 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

What do you understand by mirroring?

0 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---