记录下作业,sql serve语句随便写写
CREATE DATABASE ML
USE ML
CREATE TABLE t_user(
id INT,
userName VARCHAR(20),
password VARCHAR(20),
);
INSERT INTO t_user(id, userName,password)
VALUES (1, '001', '123456');
CREATE TABLE TYPE(
id INT identity(1,1) PRIMARY KEY ,
typeName NVARCHAR(255) NOT NULL
);
SET IDENTITY_INSERT TYPE ON;
INSERT INTO TYPE(id, typeName)
VALUES(1,'saber')
CREATE TABLE SERVENT(
id INT identity(1,1) PRIMARY KEY ,
typeName NVARCHAR(255) NOT NULL,
ServentName NVARCHAR(255) NOT NULL
);