Tip Bank

You need just one-line function to evaluate the number of days in a month (while taking leap years into account, of course). The trick is to use the DateDiff and

‘ convert a date value into a string in the format’ YY years, MM months, DD days, HH hours, MM minutes, SS.HH seconds)’ you can also opt for time short

Private Declare Function GetLongPathName Lib “kernel32” Alias _ “GetLongPathNameA” (ByVal lpszShortPath As String, _ ByVal lpszLongPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a short

Question: How can I get Exchange to forward e-mail to an AOL or ATT account automatically? We have traveling users who have AOL or ATT accounts and would like all

Question: From a previous version of SQL Server 7.0 I saved only contract_Data.MDF and contract_Log.LDF. How can I insert this file in my current SQL Server 7.0? Answer: Here are

Question: What is the difference between two dates, date1 and date2, when date2 is in the next record? Answer: Use this code: select datediff(laterone.date1, earlierone.date1) from table earlierone, table lateronewhere

Question: How can I get the number of records returned by a query without cycling through all the records and counting each one? Answer: Have you tried SELECT COUNT(*) FROM

Question: I just installed SQL 7 on my server and have an Access database that contains a lot of information. How do I create a SQL database? Also, is there

Question: I am a student. Is there a way to load a database into Oracle to run my exercises? Answer: I’m not sure I can help you because there’s more