Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5235 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 |
Can u explain me What is encapsulation?
7 Answers Deloitte, GK companies,
What is WSDL? Explain its architecture?
what is the keyword used for self reference?
What is a strategy pattern? Implement it.
What is the difference between response.write & response.output.write?
what is the use of "mustinherit" keyword?
how to connect database connectivity in dotNET? if suppose SQL server?and also MS access?
What is marshling?
Explain the Difference between value and reference type.
Which file is taken by compiler when we have both file Application and Server Configuration file?
What does jit do?
What is the purpose of IClonable interface in .NET?
0 Answers Sans Pareil IT Services,
Dot Net Framework 
