Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5411 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
What is il and c#?
How to create multiple inheritance in c#, with example?
What is delegation in .net?
How to customize the trace output?
Different levels of priority provided by .net.
Explain different types of html, web and server controls.
Explain the process of serialization in .NET?
Explain boxing and unboxing in .net.
Please explain is the jit an interpreter?
What is .net and .net framework?
What is .net standard?
What is a windows process in .net?
What is difference between .net core and .net standard?
Define satelite assembly?
Give a brief introduction on side-by-side execution. Can two applications, one using private assembly and the other using the shared assembly be stated as side-by-side executables?
