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
- 6108 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 meant by globalization and localization?
If you are executing these statements in commandobject. Select * from table1; select * from table2? How you will deal result set? 42. How do you sort a dataset.
Explain different types of cookies in .NET?
What is the use com component in .net?
What is the use of design pattern?
Can you write a class without specifying namespace?
Which dll translate xml to sql in internet information server (iis)?
What is the standard you use to wrap up a call to a Web service
what is dotnet architecture? can anyone explain that.
Which namespace does it belong to by default?
State some of the different languages supported by .net?
How does the generational garbage collector in the .net clr manage object lifetime? What is non-deterministic finalization?
Dot Net Framework 
