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 ...
Ars Technica

SQL Query Help - SELECT statement to return all values except one?

This is likely the simplest thing. I have an SMS report that lists all the software registered in a group of systems Add/Remove Programs list. I would like to modify the SQL SELECT statement that is ...
Visual Studio Magazine

Edit Your SQL Data

ActiveData assists Visual Basic 5/6 developers in their data application development. It helps you see and edit a DAO or ADO recordset's data, connection properties, recordset properties, and field ...
dbta

Relational Closure Can Turn Any SQL Select Into a Mosaic

Inside a relational database management system, the princi­pal persisted data structure is considered a logical relation. Operations performed against that data within the RDBMS result in a logical ...