What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

How make remote connection in database?

1 Answers  

---

What is the filtered index?

0 Answers  

---

How to compare the top two records using sql?

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  

---

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

---

Explain time data type in sal server 2008?

0 Answers  

---

Explain about extended stored procedure?

0 Answers  

---