sql 表（datatable）

最新推荐文章于 2021-02-26 00:32:57 发布

曹振华

最新推荐文章于 2021-02-26 00:32:57 发布

阅读量752

点赞数

分类专栏： sql server 文章标签： t-sql table

本文链接：https://blog.csdn.net/chadcao/article/details/5994157

版权

sql server 专栏收录该内容

77 篇文章 0 订阅

订阅专栏

--------------------------------
---------数据表操作-------------
--------------------------------
use stuDB
go
if exists (select * from sysobjects where name='stuInfo')
 drop table stuInfo
go
create table stuInfo
(
 stuName varchar(20) not null,
 stuNo char(6) not null,
 stuAge int not null,
 stuID numeric(18,0),
 stuSeat smallint identity(1,1),
 stuAddress text
)
go
if exists (select * from sysobjects where name='stuMarks')
 drop table stuMarks
go
create table stuMarks
(
 examNo char(7) not null,
 stuNo char(6) not null,
 writtenExam int not null,
 labExam int not null
)
go
insert into stuInfo (stuName,stuNo,stuAge,stuID,stuAddress) values('张三','2',16,18,'北京')
insert into stuInfo (stuName,stuNo,stuAge,stuID,stuAddress) values('里斯','3',15,19,'北京')
insert into stuInfo (stuName,stuNo,stuAge,stuID,stuAddress) values('王五','4',16,20,'北京')
insert into stuInfo (stuName,stuNo,stuAge,stuID) values('丽日','5',16,21)