Category Archives: MS Access

MS Access MS SQL

Calculate Execution and Cpu Time in SQL 2005

26 June, 2011 – 10:36 am

SET STATISTICS TIME ON Select * from TableName — Or Any Query SET STATISTICS TIME OFF It Results: =============== SQL Server parse and compile time: CPU time = 31 ms, elapsed time = 141 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 1 ms.

Tags , | Comment (1)
MS Access

Filter data by date time in MS access, Select only date without selecting time from date time field in MS Access

2 October, 2010 – 4:37 pm

Select * from TransactionInfo where CDate(Int([CreatedDate])) between #2010-05-04# and #2010-05-05# —————– it will return date like —————– 23-May-2010 Select * from TransactionInfo where [CreatedDate] between #2010-05-04# and #2010-05-05# —————– it will return —————–

Tags | Comment (0)
Page 1 of 11