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
- 6090 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 |
Explain security measures exist for .net remoting in system.runtime.remoting?
SAP Business One(this is intigrated tool of .net)
What is CLR, CLS,CTS
4 Answers Deloitte, Vee Technologies,
Is there any attempt system for microsoft technology papers?
Tell me what is a “jagged array”?
What is alias ? Is it used in .Net ?
What does the "EnableViewState" property do?
What is Entity Relationship Model in .NET?
Tell us the differences between an interface and an abstract class in .net?
How to load the contents of an xml file into an xmldocument object?
Interop Services?
What is an assembly? What are the different types of assemblies?
Dot Net Framework 
