Computerworld

How to delete database rows with a JOIN statement

SQL delete rows with join Here’s a quick and simple tip to delete database rows when a JOIN statement is required to filter the data. This question pops up more than you might think as it’s not ...
Simon Fraser University

Reading and Updating Data with the SQL Procedure

To update DBF data, you can specify view descriptors in the SQL procedure's INSERT, DELETE, and UPDATE statements. You can also use these statements to modify SAS data files. However, the ability to ...
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 ...
ZDNet

Sybase triggers protect your data

Automating routine tasks is the hallmark of a great application. This automation allows the developer to tackle more important issues. Triggers provide automation to database developers. This article ...
Simon Fraser University

Reading and Updating Data with the SQL Procedure

In Version 6, the SAS System's SQL procedure enabled you to retrieve and update data from DBMS tables and views. You could read and display DBMS data by specifying a ...