SQL Server data/input validation

([id] [int] identity(1,1), [name] [nvarchar], [magicvalue] [int])

CREATE TABLE [dbo].[SalesHistory](
      [SaleID] [int]  NOT NULL,
      [Product] [char](150) NULL,
      [SaleDate] [datetime] NULL,
      [SalePrice] [money] NULL CHECK (SalePrice > 4)

)