Ars Technica

sql IF statements - using query results as conditionals

I'm trying to get better aquainted with conditional sql statements, using variables, loops, and all that other junk. (This is MSSQL 2000 by the way)<BR><BR>My test is that I want to try to cycle thru ...
TechRepublic

SQL JOINs make it easy to find and fix missing data

Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax. In response to previous SQL lessons, TechRepublic ...
Ars Technica

SQL: If statement in SELECT statement, concatenation in SQL statment?

I have a table that has 2 fields, postDate, and postTime.<BR><BR>I want to select all the the records where<BR><BR>1. the current date is later than the post date.<BR>2. The post time is later than ...
Simon Fraser University

CONNECT Statement

Using the CONNECT statement is optional for some DBMSs. However, if it is not specified, the default values for all of the database connection arguments are used. Any return code or message that is ...