Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5226 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer / 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
| Is This Answer Correct ? | 2 Yes | 2 No |
What is marshling?
Explain the .net framework overview?
How to Exchange data between Webservices
In Mvc Architecure what is view?
State the methods used during deserialization and serialization process.
What is the model role in Mvc architecture?
What are the authentication methods in .net?
What are the benefits of Model-View-Controller Architecture?
Explain me what is an anonymous method and how is it different from a lambda expression?
What is the single responsibility principle?
What are the features of dot net?
Difference between value type & reference types ?
Dot Net Framework 
