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
4237 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

what purpose does the model database serve? : Sql server database administration

957

What is correlated subquery in sql server?

1049

What do you mean by data integrity?

1045

What is factless fact table? : sql server analysis services, ssas

1008

How to concatenate two character strings together?

1101

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

944

Is sql server 2016 free?

912

What is server-level principal?

122

Differentiate between ms sql server reporting services vs crystal reports?

889

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

929

What are dml triggers and types of dml triggers?

963

What is update locks?

869

How to stop a loop early with break statements in ms sql server?

996

What is DCL?

1031

What is the default value of an integer data type in sql server 2005?

941