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
- 5951 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 |
what is machine key error in .NET how can we solve it?
Is .net an object oriented language? What are their components?
Explain what is an anonymous method and how is it different from a lambda expression?
What is connected and diconnected database ?
What is the difference between function and stored procedure?
Please explain what is the .net framework and how does it work?
What is marshling?
What are .net functions?
Which method do you use to redirect the user to another page without performing a round trip to the client?
What is COM Interoperability in .NET
What base class do all Web Forms inherit from?
What is a delegate in .NET?
Dot Net Framework 
