Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5410 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 are the types of assemblies in .net?
What is JIT and how is works?
What is the use of trace utility?
Describe difference between inline and code-behind?
Please explain what garbage collection is and how it works. Provide a code example of how you can enforce garbage collection in .net?
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?
What tools is used to develop .NET applications?
What is .net and .net framework?
What is the advantage of packaging over xcopy in .net?
When developing a Windows service for .NET, which namespace do you typically look in for required classes?
What do you mean by Driver Script?
What application do you use to install a Windows service?
Dot Net Framework 
