How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

Where is my database stored on the hard disk in ms sql server?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

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  

---

what is a self join? : Sql server database administration

0 Answers  

---

what is differece between union and union all

6 Answers  

---

How to get the definition of a trigger back?

0 Answers  

---

What are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

How do you create a data source?

0 Answers  

---

Define primary key?

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

IN Vs OR operator which is best to use sql server.

4 Answers  

---