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
- 4229 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 is scheduled job and how to create it?
why would you call update statistics? : Sql server database administration
Define views.
What is multilevel indexing?
Write a program using SQL queries to find a unique entry in a table.
How to create sub reports?
What stored by the msdb? : sql server database administration
Why variables called the most powerful component of ssis?
What is measure group, measure? : sql server analysis services, ssas
how can you check the level of fragmentation on a table? : Sql server administration
What is the minimum recommended amount of ram for sql server 2012 enterprise?
Explain concepts of analysis services?
What do you mean by subquery?
What do you understand by check constraint in sql server?
Is it possible to call a stored procedure within a stored procedure?
