Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5262 Views
- Deloitte, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between managed and unmanaged code?
What is Flyout Design Pattern in .NET?
What is the purpose of IClonable interface in .NET?
What is STA in .NET?
Difference between value type & reference types ?
what will do to avoid prior case?
What is strong-typing versus weak-typing? Which is preferred?
What is connected and diconnected database ?
Name the classes that are introduced in the system.numerics namespace.
Tell us the differences between an interface and an abstract class in .net?
What is concurrency? How will you avoid concurrency when dealing with dataset?
What is a manifest in .net?
What are the purposes of using .net?
Should I implement finalize on my class? Should I implement idisposable?
What are the new features of Framework 1.1 ?
