Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
student table create
CREATE TABLE student( ID INT NOT NULL IDENTITY(1,1), NAME VARCHAR(20) NOT NULL, AGE INT NOT NULL, PRIMARY KEY(ID) ); CREATE TABLE curs( ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY, NAME VARCHAR(20) NOT NULL, CREDITE INT NOT NULL CHECK(CREDITE >=0 AND CREDITE <10) ); CREATE TABLE INSERT INTO student VALUES('Dan', 23); INSERT INTO student VALUES('Fane', 23); INSERT INTO student VALUES('Alex', 22); INSERT INTO student VALUES('Rotter', 16); INSERT INTO curs VALUES('POO', 6); INSERT INTO curs VALUES('SO', 4); INSERT INTO curs VALUES('Arhitecturi', 6);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
base de datos dbfloreria
Primeiro
dbms pracs
Stuff
archu
Crea, confirma y despliega tablas
shrink logs
Status History
Función Borrar carácter inicial repetido
employee table
Please log in to post a comment.