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  

---

What are the advantages of using stored procedures?

0 Answers  

---

Explain the properties of a relational table?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

What is the default Port No on which SQL Server listens?

0 Answers  

---

---

How can you stop stored procedures from recompiling?

0 Answers  

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---

What is coalesce in sql server?

0 Answers  

---

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

How to add code to the existing article (using improve article)?

0 Answers  

---

Can we update data in a view?

0 Answers  

---