Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5678 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 |
why you wouldn't want to write into it even if you could
How to get the hostname or IP address of the server?
When we use windows api in .net is it managed or unmanaged code?
Difference between class and interface in .net?
What is common language specification (cls)?
Name some of the languages .NET support?
What is the difference between override and overload in a method?
What is a formatter in .net?
Explain how garbage collection works?
where are connection strings stored?
What is managed code and managed data in .net?
Explain about the Common Language Runtime?
Dot Net Framework 
