Example: select col1 from table_name where (( convert(DateTime,Date

Write an StoredProcedure to get the values of a column
within a date range.

Question Posted / suren

1 Answers
6091 Views
Deloitte, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the difference between .net 2000 and .net 2005(features)? Which one is better?

1076

What is view state in .net?

1082

Explain me what is the difference between an abstract class and an interface?

1080

What is machine.config in .net?

1078

Explain the difference between public and static modifiers?

1211

What is jit compilers?

1215

Why is .net used?

1055

Explain code access security.

1061

Explain the code behind wors and contrast that using the inline style.

1071

hai, about trading domain and need simple project on trading system. please help me...

2121

Explain what are an object and a class?

1138

How big is the datatype int in .net?

1142

What is .net latest version?

1095

What is .net code security?

1064

What are the differences between com architecture and.net architecture?

1139