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
- 6035 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 do you mean by Driver Script?
C++ & C# differences ?
Is .net core the future?
What is the difference between function and stored procedure?
What is meant by globalization?
What is the model role in Mvc architecture?
ctype(123.34,integer) - should it throw an error? Why or why not?
What are the main components in .net?
What is RunTime Polymorphism?
5 Answers Deloitte, eClerx, Horizon, Intel, Pragna Technologies,
Explain the .net framework overview?
What is Full trust permission set in .Net
What are the differences between com architecture and.net architecture?
Dot Net Framework 
