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 is stored procedure ? how we use it in .NET ?

1085

---

How server form post-back works?

1083

---

What's the problem with .net generics?

983

---

How do you define the lease of the object in .net?

998

---

Explain the difference between asp.net & vb.net and explain architecture?

995

---

Write a program to create a user control with name and surname as data members and login as method and also the code to call it.

926

---

Tell me what is serialization?

1018

---

What is garbage collection? Explain the difference between garbage collections in .net 4.0 and earlier versions?

1095

---

How to spawn a thread?

1024

---

What are virtual destructures?

1080

---

What is the difference between function and stored procedure?

1108

---

What is the difference between override and overload in a method?

1185

---

What operating systems does the .net framework run on?

999

---

How is meant by dll in .net?

1029

---

What is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?

988

---