Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
Simon Fraser University

DESCRIBE Statement

The DESCRIBE TABLE statement writes a CREATE TABLE statement to the SAS log for the table specified in the DESCRIBE TABLE statement, regardless of how the table was originally created (for example, ...
TechRepublic

SQL basics: SELECT statement options

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...
Simon Fraser University

Controlling Locks

When the interface view engine reads data from a CA-OpenIngres table or view, an SQL SELECT statement is issued to place a shared lock on the table. (A shared lock enables more than one user to access ...