Explain transaction isolation levels in sql server?

0 Answers  

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---

Explain about analysis services?

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  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

What are information schema views?

0 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

what is mean by constraints in sql?

5 Answers   Granada, IBM,

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

What is cross join in sql server joins?

0 Answers  

---