create database VoteDB//创建数据库
go
use VoteDB
go
create table Votes//创建表
(
VoteID int identity(1,1) primary key,
Item nvarchar(200) not null,
VoteCount int not null,
)
go
select * from votes
go
//插入表
insert into votes(Item,VoteCount) values('中国功夫','100')
insert into votes(Item,VoteCount) values('李小龙','100')
insert into votes(Item,VoteCount) values('博天视翼','100')
//从选票信息表Votes中获取所有选票信息
create proc GetVotes
as
select * from Votes
go
exec GetVotes
//添加一条新记录到选票信息表Votes
create proc AddVote(@Item nvarchar(200),@VoteCount int)
as
insert into Votes(Item,VoteCount)values(@Item,@VoteCount)
go
//从选票信息表Votes中删除一条选票信息
create proc DeleteVote
as
delete from Votes
go
//更新参与投票项目的票数
create proc UpdateVote(@VoteID int,@VoteCount int)
as
update Votes set VoteCount=@VoteCount+1 where VoteID=@VoteID
go