Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5231 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 |
Will it go to finally block if there is no exception happened?
Explain difference between panel and groupbox classes using .net?
What do the terms “boxing” and “unboxing” mean?
Please explain is the jit an interpreter?
Which ports are used by virueses?
Please explain what is the difference between encrypting a password and applying a hashing?
If I am writing in a language like vb or c++, what are the procedures to be followed to support .net?
What is the base class of Button control?
What is PageIndex in DataGrid?What is the event used in the Datagrid for while moving from one page to another page in the Grid?write code for it
What is namespaces in .net?
What is il in vb.net?
What are the different.net tools which you used in projects?
Dot Net Framework 
