Interested to Buy Any Domain ? << Click Here >> for more details...
Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 6040 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 |
Explain the difference between constants and read-only variables?
can we use private assembly in other project in dot net.
What is misl?
What is the difference between vb.net and vc#.net?
Can I write my own .net host?
Why you want to leave your previous company.
Explain attributes in dot net?
What is use of ContextUtil class?
Explain what is immutability, what is it for and how is it codified?
What is the procedure to add assemly to gac to make it shared one?
What are the collections you've used?
What are the differences in C# .Net and ASP .Net.
Dot Net Framework 
