帮我解决一下！各位老大哥，老大姐！

[same666]

alter procedure listcustwithage
@mindiscount dec(28,3)
as
select *
from personnel
where status
And age.=@minage
服务器: 消息 156，级别 15，状态 1，过程 listcustwithage，行 7
在关键字 'And' 附近有语法错误。

[guo]

where后的语句最终结果是true/false
status类型如果是布尔型应该是status=true and age=@minage

[same666]

alter procedure listcustwithage
@mindiscount dec(28,3)
as
select *
from personnel
where status ture
And age.=@minage
第 6 行: 'ture' 附近有语法错误。

[zhoukan]

试试吧

[same666]

alter procedure listcustwithage
@mindiscount dec(28,3)
as
select *
from personnel
where status=ture And age=@minage
必须声明变量 '@minage'。

[same666]

如何声明@minage为变量？？？？？？？？？？？？？？？？？？？？？？？？？？？
？？？？？？？？？？？？？？？？？？？
？？？？？？？？？？？？

[NIERR]

declare @minage int
alter procedure listcustwithage
@mindiscount dec(28,3)
as
select * from personnel
where status=ture And age=@minage
要确定有参数输入。