Ask a Question related to ASP, Design and Development.
-
Bhavin #1
Time query
What should be SQL statement in asp to update time field
(in MSACCESS) with current time?
Bhavin Guest
-
Query Excution Time
Question on query excution time. I have a mx application querying Oracle database, there is about ten records only, but the debugging information... -
query time
On Wed, 02 Feb 2005 14:48:41 +0000, Richard Huxton <dev@archonet.com> wrote: Unfortunately, all my cases are LIKE '%john_doe'. So I'm guessing... -
Query Processing Time
How can i set the Query Processing Time in my asp page. i am getting this error messages "Estimated query processing time 152 exceeds limit 30" ... -
Query execution time?
Hi all, 1. Select * from table where ADEDATE = '23 June 2003' in SQLServer2000 This one works fine immediately. 2.Select * from table where... -
need advice for query time on Oracle
jyou wrote: General statements are difficult to debug. For one thing, you have to take into account the network load ... since you're comparing a... -
Ken Schaefer #2
Re: Time query
strSQL = "UPDATE myTable SET myTimeField = Time()"
Time() is an inbuilt VBA function that returns the current system time.
Cheers
Ken
"Bhavin" <anonymous@discussions.microsoft.com> wrote in message
news:06b301c397a0$cb4c90a0$a601280a@phx.gbl...
: What should be SQL statement in asp to update time field
: (in MSACCESS) with current time?
Ken Schaefer Guest



Reply With Quote

