Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5648 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 what is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?
What is the difference between server.transfer and response.redirect? Why?
Is string a value type or a reference type?
which methos do you invoke on the dataadapter control to load your generated dataset with data?
Explain the Scope of public/private/friend/protected/protected friend.
what is prototype design pattern in .net
What is .net latest version?
Explain the main components in .net?
How does cas works?
What is use of ContextUtil class?
State the various features present in .NET?
Can we have same method with same name and signature using partial classes
Dot Net Framework 
