´«ÖDz¥¿ÍÎÒµÄSqlServer½Å±¾

 
======================SqlServer´ó²¿·Ö֪ʶ¶¼ÔÚÎÒÕâ½Å±¾Àï===============
Èç¹ûÄãÄÜ°ÑÊý¾Ý½á¹¹»­³öÀ´µÄ»°£¬ÄÇôÄã¾ÍÈëÃÅÁË£¡£¡ºÇºÇ£¡£¡
--²é¿´konwyoumore¿âÊÇ·ñ´æÔÚ
USE master
IF exists(SELECT * from sysdatabases WHERE name='KnowYouMore')
BEGIN
DROP DATABASE knowyoumore;
END
GO
--´´½¨konwyoumoreÊý¾Ý¿â
CREATE DATABASE KnowYouMore
GO
USE KnowYouMore
GO
--´´½¨½ÇÉ«±í
CREATE TABLE roles
(
rno INT PRIMARY KEY IDENTITY(1,1),
rname VARCHAR(12) NOT NULL
);
GO
--´´½¨×¢²á±í
CREATE TABLE users
(
uno INT PRIMARY KEY IDENTITY(1,1),
uname VARCHAR(32) NOT NULL UNIQUE,
upwd VARCHAR(32) NOT NULL ,
star INT,
trueName VARCHAR(16) NOT NULL,
rno INT FOREIGN KEY REFERENCES roles(rno)
);
GO
--´´½¨°à¼¶±í
CREATE TABLE classes
(
cno INT PRIMARY KEY IDENTITY(1,1),
cname VARCHAR(32) NOT NULL UNIQUE,
   cdescribe VARCHAR(100)
);
GO
--´´½¨Ñ§Éú±í
CREATE TABLE students
(
sno INT PRIMARY KEY IDENTITY(1,1),
sname VARCHAR(16) NOT NULL UNIQUE,
sex CHAR(2) NOT NULL CHECK(sex='ÄÐ'or sex='Å®') DEFAULT('ÄÐ'),
birth DATETIME NOT NULL DEFAULT getdate(),
nativeplace VARCHAR(16) NOT NULL,
address VARCHAR(100) NOT NULL,
QQNo VARCHAR(32) NOT NULL,
phoneNo VARCHAR(12) NOT NULL,
nowTerm VARCHAR(5) NOT NULL,
selfPic VARCHAR(100) DEFAULT '6666.jpg',
selfDescribe VARCHAR(100) NOT NULL,
cno INT FOREIGN KEY REFERENCES classes(cno)
);
GO
--´´½¨½Ìʦ±í
CREATE TABLE teachers
(
tno INT PRIMARY KEY IDENTITY(1,1),
tname VARCHAR(16) NOT NULL UNIQUE,
sex CHAR(2) NOT NULL CHECK(sex='ÄÐ'or sex='Å®') DEFAULT('ÄÐ'),
birth DATETIME NOT NULL DEFAULT getdate(),
nativeplace VARCHAR(16) NOT NULL,
taddress VARCHAR(100) NOT NULL ,
tQQNo VARCHAR(32) NOT NULL,
tphoneNo VARCHAR(12) NOT NULL,
selfPic VARCHAR(100),
selfDescribe VARCHAR(100) NOT NULL,
nowTerm VARCHAR(5) NOT NULL,
cno INT FOREIGN KEY REFERENCES classes(cno)
);
GO
--´´½¨Òâ¼û±í ÿÌìѧϰÆÀ·Ö
CREATE TABLE stuQuestion
(
sname VARCHAR(16),
cname VARCHAR(32) FOREI