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

What method do you use to explicitly kill a users session? How?

963

---

Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component

2401

---

What is Event - Delegate? clear syntax for writing a event delegate

1966

---

What is the difference between asp.net and asp?

1094

---

What is DTS and explain the purpose of it?

1006

---

How to create multiple inheritance in c#, with example?

1007

---

What is common type system (cts)?

937

---

What is COM Interoperability in .NET

1023

---

What is the intermediate language between asp and asp.net1.0?

1921

---

Tell us what do the following acronyms in .net stand for: il, cil, msil, cli and jit?

887

---

Different between .net & j2ee ?

1022

---

Please explain what garbage collection is and how it works. Provide a code example of how you can enforce garbage collection in .net?

932

---

What is il in vb.net?

979

---

Explain me what is the .net framework and how does it work?

1012

---

Tell us the difference between managed and unmanaged code?

954

---