What are the different types of join?

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

What command would you use to create an index?

0 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

what is datawarehouse?

0 Answers   Informatica,

---

What is instead of trigger sql server?

0 Answers  

---

What is a data collection table?

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---

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  

---