there is another table that has events stored, and linked to a calendar. For instance, there might be an event on March 31st that's linked to calendar_ID 15. <P>How do I delete all the events that ...

A common SQL habit is to use SELECT * on a ... If you have a table you’re constantly archiving into another table, you can avoid using INSERT/DELETE to move the data, and use SWITCH instead.

Relationships between tables are required for cascading updates or delete statements; these relationships are defined through FOREIGN KEY constraints. (Here’s more information on defining SQL ...

If you are using descriptors, you can specify them in the SQL procedure's INSERT, DELETE, and UPDATE statements. You can also use these statements to modify SAS data files. The ability to update data ...