How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

---

What is an expensive query?

0 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

Mention the differences between sql server and mysql.

0 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

---

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 rest identity columns in sql server

3 Answers   Matrix,

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

in how many ways we can use count()

2 Answers  

---

What is entity data services?

0 Answers  

---