1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

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 is a data source file?

505

How to filter records of table in SQL SERVER?

603

Why are views required in the sql server or in any other database?

544

Explain about sql server login?

601

What is the contrast between sql and pl/sql?

627




How do I delete a sql server database?

551

How many types of triggers are there?

574

What is clustered vs nonclustered index?

509

How to generate create procedure script on an existing stored procedure?

514

How to link tables in sql server?

481

What is 2nf normalization?

544

What is difference between table aliases and column aliases? Do they affect performance?

510

How to stop log file growing too big?

580

What is use of except clause? How does it differ from not in clause?

558

Which is faster statement or preparedstatement?

538