Write an StoredProcedure to get the values of a column
within a date range.
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 |
Please send me the latest asp.net,c#,sql server interview questions .my email id is ramtryin@gmail.com
What is the difference between asp.net & vb.net and explain architecture?
differance between checkbox and rediobutton in vb.net?
What is Garbage Collection in .Net? Garbage collection process?
Should I implement finalize on my class? Should I implement idisposable?
Please explain the difference between constants and read-only variables?
How to implement datagrid in.net? How would you make a combo-box appear in one column of a datagrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for datagrid methods. What is the access specifier used for that methods in the code behind file and why?
Can you edit data in repeater control? How?
What is Atomicity?
How many types of generations are there in a garbage collector?
What versions of .net are there?
What is WSDL? Explain its architecture?