用TSQL定义SQL Server约束

IF OBJECT_ID('SalesHistory')>0
      DROP TABLE SalesHistory;

GO

CREATE TABLE [dbo].[SalesHistory](
      [SaleID] [int]  NOT NULL,
      [Product] [char](150) NULL,
      [SaleDate] [datetime] NULL,
            [SalePrice] [money] NULL, 
      CONSTRAINT chk_ProductSalePrice CHECK (SalePrice>10 AND Product='Computer')
)

GO