SQL Server 2000I need to change the collation for a database from case senstitive to case insensitive. ALTER DATABASE COLLATE SQL_Latin1_General_CI_AS When I try to so, I get a whole slew of ...

CREATE TABLE SalesHistory (SaleID int IDENTITY(1,1) NOT NULL, ProductID TINYINT, CustomerID INT, ... You can use cascading constraints in SQL Server to set related values to NULL, ...

Check constraints are supported in all of the major DBMS products, including DB2, Oracle, and SQL Server. But they are too-often ignored and not implemented in production databases. Properly defined, ...