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
- 6016 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 are the purposes of using .net?
Explain what are possible implementations of distributed applications in .net?
what is GAC?
Can u explain me What is encapsulation?
7 Answers Deloitte, GK companies,
What is .net environment?
Name the classes that are introduced in the system.numerics namespace.
Please explain what do the terms “boxing” and “unboxing” mean?
Which two properties are on every validation control?
Explain what do the terms “boxing” and “unboxing” mean?
What is the managed and unmanaged code in .net?
how to connect database connectivity in dotNET? if suppose SQL server?and also MS access?
What is the microsoft .net?
Dot Net Framework 
