Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to store time (not date) in SQL and query from VFP
Message
From
06/03/2008 19:28:58
 
 
To
06/03/2008 17:43:08
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01297626
Message ID:
01299592
Views:
30
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"
Previous
Reply
Map
View

Click here to load this message in the networking platform