Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4260 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
What are acid properties of transaction?
Explain about merge replications?
What are the advantages of log shipping?
How to assign null values to variables or columns?
How can I know what locks are running on which resource?
How to name query output columns in ms sql server?
What is importing utility?
Can you use order by when defining a view?
How do I install only the client tools of sql server 2000?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is explicit mode in sql server?
Explain sql server service broker?
What is the difference RDBMS and Graph Database?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is data set in report?
