用SQL创建存储过程时出现错误？那位高手帮我看下
/*存储过程Pr_GetVotes */
create proc Pr_GetVotes
AS
select *
from Votes
order by VoteID

/* 存储过程Pr_GetSingleVote*/
create proc Pr_GetSingleVote
(
@VoteID int
)
AS
select Votes.*
from Votes
where VoteID = @VoteID

/*存储过程Pr_AddVote*/
create proc Pr_AddVote
(
@Item varchar(100)
)
AS
insert into
Votes(Item,ItemCount)
Values(@Item,0)
return @@Identity

/*存储过程Pr_UpdateVote*/
create proc Pr_UpdateVote
(
@VoteID int
)
AS
Update Votes
set VoteCount = VoteCount + 1
where VoteID = @VoteID

/*存储过程Pr_DeleteVote*/
create proc Pr_DeleteVote
(
@VoteID = int
)
AS
delete Votes
where VoteID = @VoteID


是一个在线投票系统的数据库中创建存储过程

[解决办法]
/*存储过程Pr_GetVotes */
create proc Pr_GetVotes
AS

select *
from Votes
order by VoteID

go
/* 存储过程Pr_GetSingleVote*/
create proc Pr_GetSingleVote
( @VoteID int)
AS
select Votes.*
from Votes
where VoteID = @VoteID

go
/*存储过程Pr_AddVote*/
create proc Pr_AddVote
(
@Item varchar(100)
)
AS
insert into
Votes(Item,ItemCount)
Values(@Item,0)
return @@Identity
go

/*存储过程Pr_UpdateVote*/
create proc Pr_UpdateVote
(
@VoteID int
)
AS
Update Votes
set VoteCount = VoteCount + 1
where VoteID = @VoteID

go

/*存储过程Pr_DeleteVote*/
create proc Pr_DeleteVote
(
@VoteID int
)
AS
delete Votes
where VoteID = @VoteID