CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) )

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 / durga prasad

2 Answers
3274 Views
I also Faced
E-Mail Answers

Answer Posted / durga prasad

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType
varchar(50) )
go
alter trigger hpms_create_Insert on HPMS_CompetencyTypes
for insert
as
begin try
if Exists ( select * from [HPMS_CompetencyTypes]
where CompetencyType=(select CompetencyType from inserted))
begin
select * from [HPMS_CompetencyTypes]
end
end try
begin catch
Rollback tran
Raiserror ('duplicate value',12,6)
end catch

go
insert HPMS_CompetencyTypes (CompetencyType) values ('new')

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does asynchronous call backs means?

625

What is the difference between count () and rowcount ()?

528

How will you find out if there are expensive SQL statements running or not?

585

What is bulkcopy in sql?

564

What do you understand by sql server agent?

538

Do you know nested transaction?

516

How self join is different from outer join?

605

What is a select query statement in ms sql server?

583

What is federation member?

What are scalar functions in sql?

613

What is difference between commit and rollback when used in transactions?

504

Is ssrs support other database except ms sql server?

What do you mean by SQL injection attack?

622

What is temporal table?

488

can any body tell me how to know the password of current user in sql server

1581