CREATE TABLE dbo.myTable
      (
          ID    int      NOT NULL,
          Name  char(20) NULL,
          CONSTRAINT chk_myTable CHECK (ID > 0 AND Name = 'Vijay')
      )