Write an StoredProcedure to get the values of a column
within a date range.
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
Explain about the Common Language Runtime?
Which Namespace is used to to achieve MultiThreading in .NET?
i m fresher,hav SQL knowledge but in my ofc. i hav to work on dotnet. so plz tell me how to learn it,? from where to stat? i hav C prog. knowledge, ASP.net
Explain why do we use msmq?
What is the native image generator?
Explain the purpose of Remoting in .NET?
What is typical about a windows process in regards to memory allocation in dot net?
What is the difference between response.write & response.output.write?
How to implement datagrid in.net? How would you make a combo-box appear in one column of a datagrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for datagrid methods. What is the access specifier used for that methods in the code behind file and why?
When we use windows api in .net is it managed or unmanaged code?
How many types of generations are there in a garbage collector?
How many types of transactions are there in com + .net ?
What is the difference between .net 2000 and .net 2005(features)? Which one is better?
How is .net able to support multiple languages?
What is the advantage of packaging over xcopy in .net?