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) My test is that I want to try to cycle thru all of ...
Ars Technica

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

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