sql代码

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