Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving date and time and getting date
Message
De
26/02/2010 09:17:44
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
01450712
Message ID:
01451223
Vues:
57
>Metin,
>
>In SQL Server you can not create an index using a function. Use a date range when looking for a date, e.g.
>
>select * from myTable where DateField >=@Today and DateField < @Tomorrow
>
Thank you all,
I'll use Naomi's way. I use in first variable today 00:00 and second variable today 24:59:59 . I'm afraid of about performance in other ways. I'm not sure if sql server will use index with other ways...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform