create table using t-sql in sql server
Table can be by the following command.
default is used to put default value in the field if we don't provide any to the field we specified with default value.
check constraint is used to put check on filed if . In this example we have put check on salary field (it means that if we enter salary<8000 it will show error that salary can not be less than 8000)
Table can be by the following command.
default is used to put default value in the field if we don't provide any to the field we specified with default value.
check constraint is used to put check on filed if . In this example we have put check on salary field (it means that if we enter salary<8000 it will show error that salary can not be less than 8000)
Post a Comment
Post a Comment