Write an StoredProcedure to get the values of a column
within a date range.
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 Assembly?
How will you load an assembly which is not referenced by current assembly?
where are connection strings stored?
Why SOAP is required?
How to implement getcommon method in class a? Are you seeing any problem in the implementation?
Should I use readerwriterlock instead of monitor.enter/exit?
How to customize the trace output?
What's typical about a windows process in regards to memory allocation in .net?
Is .NET a runtime service or a development platform?
Explain cas (code access security)?
How would ASP and ASP.NET apps run at the same time on the same server?
What is common language specification (cls)?