beckyUp的博客

新建教学管理表CREATE DATABASE jxglGOUSE jxglGoCreate Table Student(Sno CHAR(5) NOT NULL PRIMARY KEY(Sno), Sname VARCHAR(20), Sage SMALLINT CHECK(Sage>=15 AND Sage<=45), Ssex CHAR(2) DEFAULT...

CREATE DATABASE jxglGOUSE jxglGoCreate Table Student(Sno CHAR(5) NOT NULL PRIMARY KEY(Sno), Sname VARCHAR(20), Sage SMALLINT CHECK(Sage>=15 AND Sage<=45), Ssex CHAR(2) DEFAULT'男' CHECK(S...

create table sales(客户代号 char(5)PRIMARY KEY,数量 int null)insert into sales values ('A0001',0)alter procedure modi_m AS declare @i int declare @sl int set transaction isolation level read ...