一、准备工作:
1、首先我们创建测试数据库:
create
database
demo
2、创建数据表和测试数据:(这里注意外键控制)
use
demo
CREATE TABLE student
(
stuid int NOT NULL PRIMARY KEY ,
stuname varchar ( 50 )
)
CREATE TABLE score
(
stuid int NOT NULL REFERENCES student(stuid),
score int
)
GO
INSERT INTO student VALUES ( 101 , ' zhangsan ' )
INSERT INTO student VALUES ( 102 , ' wangwu
CREATE TABLE student
(
stuid int NOT NULL PRIMARY KEY ,
stuname varchar ( 50 )
)
CREATE TABLE score
(
stuid int NOT NULL REFERENCES student(stuid),
score int
)
GO
INSERT INTO student VALUES ( 101 , ' zhangsan ' )
INSERT INTO student VALUES ( 102 , ' wangwu