Interview Questions Answers in SQL Server, Dot Net AllOther

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 # 9499

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 4154

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

3 Dot Net AllOther 5345

Answers / { indira }