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
- 6111 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 connection pooling and how do you make your application use it?
Tell us what is heap and what is stack?
Is Driver Script any how related to AOM?
In code behind class, name the type of code found. Is it the server side code or client side code?
What is common language specification (cls)?
What is the root class in .net?
Please explain when should you use .net web forms over asp.net mvc?
What are the types of jit?
What are pdbs?
Dynamic Fonts
What is the purpose of IClonable interface in .NET?
What tags do you need to add within the asp:datagrid tags to bind columns manually.
How to load the contents of an xml file into an xmldocument object?
Tell us the difference between the while and for loop. Provide a .net syntax for both loops?
With these events, why wouldn't microsoft combine invalidate and paint, so that you wouldn't have to tell it to repaint, and then to force it to repaint?
