create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

---

Explain sp_configure commands, set commands?

3 Answers  

---

How to create a new login name in ms sql server?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

What do you understand by check constraint in sql server?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

If the job running very slow what is the action you do

0 Answers  

---

What are distributed partitioned views?

0 Answers  

---