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  

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

What is a transactions?

0 Answers  

---

What is the difference between a view and a stored procedure?

0 Answers  

---

What is the New in SQL server 2008?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

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

0 Answers  

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---