SQL sever 2008 增删改查

/*建库*/

use master

go

if exists(select * from sysdatabases where name = 'StudentDB')

drop database StudentDB

create database StudentDB

on primary

(

name = 'StudentDB_data',

filename = 'E:\DATASTORE\StudentDB_data.mdf',

size = 10MB,

filegrowth = 1MB

)

log on

(

name = 'StudentDB_log',

filename = 'E:\DATASTORE\StudentDB_log.ldf',

size = 10MB,

filegrowth = 1MB

)

go

/*建表*/

use StudentDB

go

if exists(select * from sysobjects where name = 'Students')

drop table Students

go

create table Students

(

Id int identity(100,1) primary key,

Name varchar(10) not null,

Gender char(2) not null,

Age int not null

)

go

/*插入*/

use StudentDB

go

insert into Students(Name, Gender, Age)values('lisi', '男', 10)

insert into Students(Name, Gender, Age)values('zhangsan',  '男', 20)

go

/*查询*/

use StudentDB

go

select * from Students

go

/*修改*/

use StudentDB

go

update Students set Name = 'haode' where Id = 100

go

/*删除整个表的数据*/

use StudentDB

go

truncate table Students

go

use Students

go

delete from Students

go

/*删除记录*/

use StudentDB

go

delete from Students where Id = 100

go

/*删除表*/

use Students

go

if exists(select * from sysobjects where name = 'Students')

drop table Students

go