用T——SQL语句完成

发布网友发布时间：2022-04-09 08:10

共2个回答

热心网友时间：2022-04-09 09:40

1. create database network_class_one
on
( name=stu,
filename='d:\porgram files\stu.mdf',
size=10MB,
MAXSIZE=50MB,

filegrowth=5mb
)
LOG ON
(name= stu_log,
filename='d:\porgram files\stu.log',
size=10MB,
MAXSIZE=50MB,
FILEGROWTH=5MB

)
2 .use network_class_one
go
create table StuInfo
(sno int not null primary key clustered,
sname varchar(40),
sex varchar(2),
sage int(4),
address varchar(200)
)
use network_class_one
go
create table StuResults
(sno int not null ,
sname varchar(40)
constraint fk_sno foreign key(sno,sname) references StuInfo(sno,sname),
Term varchar,
Server varchar(20),
Web varchar(200)
)
use network_class_one
go

3. alter table StuResults
add data_Technology varchar(20)
4. inster into StuInfo values("10021","张三","男","19","高山")

inster into StuInfo(son,sname,Term )values("10021","张三","一")

热心网友时间：2022-04-09 10:58

学数据库的吧，好简单的，如果有必要明天写给你，今天要下班了