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
- 4275 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
What is repeatable read?
What is normalization and its types?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is the difference between online clustering and Offline clustering?
what's the difference between delete table and truncate table commands? : Sql server database administration
Explain different types of self contained sub query?
Explain system views?
What are number line correlation administrators will use while working with a subquery?
What is BCNF? How is it better than 2NF & 3NF?
How to create a simple table to test triggers in ms sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
What should be the fill factor for indexes created on tables? : sql server database administration
Why Master database is required?
Can binary strings be converted into numeric or float data types?
What is the report builder?
