How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

Is it possible to create trigger on views?

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

What is an indexed view?

0 Answers  

---

---

Explain multiserver query

0 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

how to generate XML out of QUERY?

1 Answers   McAfee,

---

What is the difference between truncate and delete commands?

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What triggers long term care?

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  

---