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 |
Write Code for DataSet,Datareader,and by deleting the button gridview should be empty?
How server form post-back works?
what are the controls used to upload a file from client to server?
I was working for software company frm 2005 to 2009. I left job due to recession.I was jobless till dec 09 then i got job in bpo and i am not knowing what to do as my professional experience is with software.give me any suggestion.
I am constantly writing the drawing procedures with system.drawing.graphics, but having to use the try and dispose blocks is too time-consuming with graphicsobjects. Can I automate this?
Explain what is the difference between constants and read-only variables?
What is "common language specification" (cls) in .net?
If any body working in Infosys, please can u give me the referense to that company because i hered that their is openings for freshers with referal..
why do you want to join deloitte, where do you exactly fit in.
What is prerender event of a page?
Which dll translate xml to sql in internet information server (iis)?
What are the important components of .net?