Answer Posted / suren

Example:

select col1 from table_name where
(( convert(DateTime,Date_Column1,102) between coalesce
(@Date_Column1,convert(DateTime,Date_Column,102)) and
coalesce(@Date_Column2,convert(DateTime,Date_Column,102))))

//Date_Column: Column in the Table
//Date_Column1: first value of date range
//Date_Column12: second value of date range

Example from .net. Integer & struct are value types or reference types in .net?

1024

---

What does .net stand for?

1022

---

Explain difference between panel and groupbox classes using .net?

1050

---

Explain me what is the difference between an abstract class and an interface?

1032

---

What is manifest in .net?

1117

---

How is a managed code executed?

1429

---

What is equivalent for regsvr32 exe in .net ?

1168

---

How inheritance works in .net?

1053

---

How ccw (com callable wrapper) and rcw (runtime callable wrappers) works?

1021

---

can any one tel me the complete Testing Procedure of any one simple PROJECT i mean either web/windows based application?

1945

---

What tools can I use to develop .net applications?

1007

---

Explain the procedure to add assemly to gac to make it shared one?

988

---

What is lambda expressions in c#?

1177

---

How com+ related to the dna architecture?

1111

---

What is the base class of Button control in .NET?

1091

---