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
- 4373 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 the simplest way to create a new database in ms sql server?
How to move database physical files in ms sql server?
What are the elements of dbms?
What is a transaction and why is it important?
What is transaction server implicit?
What is the default value of an integer data type in sql server 2005?
What are the difference between primary keys and foreign keys?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Where the sql logs gets stored?
How to delete a login name in ms sql server?
what stored procedure would you use to view lock information? : Sql server administration
What is the difference between osql and query analyzer?
How to add a new dsn with the odbc driver for sql server?
Why use update_statistics command in sql server?
Explain logical operators in sql server?
