SQLServer第一章 - 初识SQLServer

3

CREATE TABLE t_user1(userId INT,name VARCHAR(32),password VARCHAR(32),phone VARCHAR(11),email VARCHAR(32), primary key(userId))
CREATE TABLE t_user2 (name VARCHAR(32),phone VARCHAR(11),email VARCHAR(32),primary key(name,phone))

4

create table t_class(id INT PRIMARY KEY,name VARCHAR(22))
create table t_student(id INT PRIMARY KEY,name VARCHAR(22),classId INT,CONSTRAINT fk_stu_class1 FOREIGN KEY(classId) REFERENCES t_claSs(id))

5

CREATE TABLE t_user(id int PRIMARY KEY IDENTITY(1,1),username VARCHAR(32) NOT NULL UNIQUE,sex int DEFAULT 0)

sqlcmd -S localhost -U sa -P '<123123Aa!@>'