阅读背景:

游标存储过程视图标值

来源:互联网 
!-- flowchart 箭头图标 勿删 --
CREATE TABLE STUDENT
(	
	SID INT PRIMARY KEY IDENTITY,
	SNAME NVARCHAR(50),
	SAGE DATETIME,
	SSEX CHAR(4)
)
CREATE TABLE TEACHER
(
	TID INT PRIMARY KEY IDENTITY,
	TNAME NVARCHAR(50)
)
CREATE TABLE COURSE
(
	CID INT PRIMARY KEY IDENTITY,
	CNAME NVARCHAR(50),
	TID INT FOREIGN KEY REFERENCES TEACHER(TID)
)
CREATE TABLE SCORE
(
	ID INT PRIMARY KEY IDENTITY,
	SID INT FOREIGN KEY REFERENCES STUDENT(SID),
	CID INT FOREIGN KEY REFERENCES COURSE(CID),
	SCORES INT
)
CREAT



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: