indira


{ City } hyderabad
< Country > india
* Profession * software developer
User No # 34078
Total Questions Posted # 2
Total Answers Posted # 0

Total Answers Posted for My Questions # 5
Total Views for My Questions # 7676

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0
Questions / { indira }
Questions Answers Category Views Company eMail

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 SQL Server 3276

Will finally block exec if we write an return statement to a try block???????

 3 Dot Net AllOther 4400



Answers / { indira }