Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
check constraint
CREATE TABLE person (id INTEGER PRIMARY KEY NOT NULL, name TEXT, age INTEGER, genderid INTEGER) insert into person(id,name,age,genderid)values(1001,'yokesh',19,1) insert into person(id,name,age,genderid)values(1002,'rajesh',19,-1) alter table person add constraint age_const check (age>18 and age<=55) insert into person(id,name,age,genderid)values(1003,'rajesh',55,-1) select* from person alter table person drop constraint age_const insert into person(id,name,age,genderid)values(1004,'ramh',99,1) select* from person
run
|
edit
|
history
|
help
0
Empleados
While Loop in SQL Server for Multiple Entries
#Temp table Collation fixed
parameters_in_procedure-join&correlated sub-query content
Turn comma-separated numbers in string into rows
TEST-A3
Q2_5MIN
test
reee
Task_3_FInal