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
- 4382 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 are the tool windows in sql server management studio? : sql server management studio
Differentiate between a primary key and a unique key.
What factors you will consider calculating the storage requirement for that view?
How extra digits are handled with numeric data type literals?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Can foreign key be duplicate?
What are the different types of replication are there in sql server 2000?
Explain indexed views and partitioned view with their syntax.
What is the difference between Stored Procedures and triggers?
Is it possible to replicate data from sql server to oracle? : sql server replication
What are null values in ms sql server?
What is the use of sign function?
Can you use order by when defining a view?
Write a SQL command to insert and update only a particular field?
Do you know what is difference between stored procedure and user defined function?
