> > No, no! The proper syntax is:
> >
> > SELECT * from KIDS
> > WHERE dinner_time = #now()#
>
> For speed, shouldn't that be...
> Select Name
> from Kids (nolock)
> where dinner_time=CreateDate()
>
> for those running SQL Server anyway
I think the SQL Server function is GETDATE(), and if you use the NOLOCK
optimizer hint, what happens if a kid is being updated or inserted while
you're selecting? You know how painful that can be. Talk about dirty reads.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
