pls try this now, CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyTy

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.

Question Posted / mano karnan

2 Answers
4257 Views
I also Faced
E-Mail Answers

Answer Posted / mano karnan

pls try this now,

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)
End
go
insert HPMS_CompetencyTypes (CompetencyType) values ('new')

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How will you decide the active and passive nodes?

1120

Explain sub-query?

941

Name few endpoints exposed by ssrs 2012?

355

What do mean by xml datatype?

1085

What is policy based management (pbm)? : sql server database administration

971

List the different normalization forms?

969

Find columns used in stored procedure?

983

What is sql server locking?

975

How to check if stored procedure is running in sql server?

1042

What is nolock?

967

Explain about nested stored procedure?

1020

How do we know if any query is retrieving a large amount of data or very little data?

966

How to list all objects in a given schema?

1050

What is correlated subquery in sql server?

1058

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1030