Ars Technica

SQL Multi-column uniqueness constraint across related tables?

I've got an interesting constraint I'm trying to add to our database. I can do with with triggers, but am curious if there is a more elegant way to do this in T-SQL (SQL2005, FWIW) We have two related ...
Ars Technica

T-SQL: Dropping Constraints from Tables.

<pre class="ip-ubbcode-code-pre"> Alter Table [MyTable] Drop [myConstraint] </pre><BR><BR>Right?<BR><BR>Anyways, I know I figured out how to do it before, and that it ...
Simon Fraser University

Integrity Constraints for SAS Tables

SCL provides a set of functions that enable you to work with integrity constraints (IC). Integrity constraints are a Version 7 feature of SAS software for preserving the consistency and correctness of ...
Semiconductor Engineering

Experts At The Table: Timing Constraints

Low-Power Engineering sat down to discuss timing constraints with ARM Fellow David Flynn; Robert Hoogenstryd, director of marketing for design analysis and signoff at Synopsys; Michael Carrell, ...
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, ...
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 ...