CREATE PROCEDURE getsinglevote
(
@VoteID int
)
as
select votes.*
from votes
where VoteID = @VoteID老报错,这是怎么回事,错误“PROCEDURE附近有语法错误,必须申明变量@VoteID”
(
@VoteID int
)
as
select votes.*
from votes
where VoteID = @VoteID老报错,这是怎么回事,错误“PROCEDURE附近有语法错误,必须申明变量@VoteID”
create table votes(voteid int)
insert votes
select 1
union select 2
union select 3go
CREATE PROCEDURE getsinglevote
(
@VoteID int
)
as
select votes.*
from votes
where VoteID = @VoteIDgoexec getsinglevote 2/*
voteid
-----------
2(1 row(s) affected)
*/