#check condition in sql

In SQL Server, you may create a check constraint in a table to specify the data values that are permitted in one or more columns. This means, that when you define a CHECK constraint on a column, it restricts the values that can be assigned to that column.

In SQL Server, you may create a check constraint in a table to specify the data values that are permitted in one or more columns. This means, that when you define a CHECK constraint on a column, it restricts the values that can be assigned to that column. Some examples- CREATE TABLE Emp( EmpNo INT, EName VARCHAR(100), Job VARCHAR(100), Mgr INT, HireDate DATE, Sal INT, Comm INT, DeptNo INT, Sal…