A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

I'm not sure if that's the right term, but how do I list records that are <B>not</B> matched to records in another table? I am joining 2 tables right now, tblPerson and tblHat, which are designed and ...

ASP Newbie here... <BR><BR>I have connectivity to my SQL database, no problem... I can output whatever records I want, no problem...<BR><BR>But I don't want to output them all at once... I want to ...

Use SQL to quickly create a new table from existing records in Access Your email has been sent SQL lets you use one command to quickly create a new table containing a subset of records from a larger ...

The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It's a bit trickier to go in the other direction ...

Microsoft has made some big promises for SQL Server 2008, a major update of its enterprise database product. No precise date has yet been announced for the launch, but the new features have caught the ...

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...

Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how. Simply use the DISTINCT clause and between the SELECT clause and the fields.

Andrews Software Inc. (ASI), Cleveland, has announced the release of VCK-SQL, the next generation of ASI’s Visual Corporate Keeper records center application. VCK-SQL uses the power and scalability of ...