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

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

Question Posted / suren

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

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

Post New Answer

More Dot Net General Interview Questions

What is a formatter?

2 Answers Infosys, TCS,

Can "this" be used within a static method?

0 Answers

String[] a = new string[10] for(i=0; i<10; i++) { a[i] = i; } How many heap object will be created for this array. Choose the answer below. Ans: 1, 10, 11, 12

6 Answers

Is there any inbuilt tool or command provided by .NET to view the code inside the assembly?

0 Answers CitiusTech,

How WSDL is stored ?

1 Answers PPS, TCS,

what is the default security setting in .net?

0 Answers

What is CLR? How it will work?

3 Answers NeoSoft,

how do you retrieve the customized properties of a .NET application from XML .config file? Can you automate this process?

1 Answers

How do you define the lease of the object in .net?