公司最近用sql server,所以想把最近学到的小案例分享出来。
进入master
use master
go
检查是否有Test1数据库,如果有,就删除
if exists (select 1 from sysdatabases where name='Test1')
begin
drop database Test1
end
go
建一个Test1数据库
create database Test1 on(
name='test1_mdf',
filename='D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\test1_mdf.mdf'
)
log on(
name='test1_ldf',
filename='D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\test1_ldf.ldf'
)
go
进入Test1数据库
新建Student表
use Test1
go
create table Student(
stuID int identity(1,1) primary key,
stuName varchar(20) not null,
stuAge int not null,
stuSex varchar(2) not null,
Address varchar(50)
)
go
做几个简单增删改查。
查询
select * from Student;
新增
insert into Student (stuName,stuAge,stuSex,Address) values('张三',18,'女','温州');
insert into Student values('李四',19,'男','海南');
修改
update Student set stuAge=20 where stuID='2';
删除
delete from Student where stuID='2';
有喜欢交流的小伙伴,欢迎联系QQ:1510101226