DBMSguy.com

Have you ever had a situation where you needed to select rows from a table for a specific month?   This example demonstrates how to retrieve all of the records belonging to the previous month by setting the first and last days in the WHERE clause of a SELECT statement.   But with some tweaking, you can [...]

Excel is a wonderful tool that can be used to write sql using substitution from cells to cusomize and update or insert.  One problem has always been dates… they never come out right

Hi folks, I was cruising around the www and found a couple of interesting sites that I thought I would pass on …