Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to store time (not date) in SQL and query from VFP
Message
De
06/03/2008 19:28:58
 
 
À
06/03/2008 17:43:08
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01297626
Message ID:
01299592
Vues:
31
I agree completely! :o)

By the way, I did figure that out on my own, however, given my stupid (actually make that extremely stupid) slipups today, I wouldn't be surprised if I couldn't figure anything out on my own today! :o)


>Right, but I thought that Tracy could figure that out on her own.
>
>You're right. What I *should* have said is "For anybody who has not taken part in recent discussions about SQL Injection, be sure NOT to add the 01-01-1901 to your datetime as part of the Select, or you're at risk of SQL Injection. Add it to the parameter and do a parameterized query."
>
>Being lazy, I took the easy way out. ;-)
>
>Hey, have you considered any further about an article? How about an article on handling dates in SQL Server? That would be cool for a lot of people here.
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform