View Single Post
  #7 (permalink)  
Old July 25th, 2007, 04:11 AM
GeertVerhoeven GeertVerhoeven is offline
Authorized User
 
Join Date: Sep 2004
Location: Edegem, Antwerpen, Belgium.
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Default

navdeep,

Oracle reason:
Although both give the same result, with the to_date function you have some overhead since you are converting to a string type which you don't have if you can compare date to date.

.NET reason:
Using parameters give you the following benefits:
- type check at compile time
- better protection against sql injection

Hope this helps.

Geert

http://geertverhoeven.blogspot.com
Reply With Quote