use masteradmit
go
declare @tempenglish int,@temppolitics int,@tempspecial int,@temptotal int
set @tempenglish='55'
set @temppolitics='60'
set @tempspecial='70'
set @temptotal='320'
go
create procedure total_message

as
if(result.english>=@tempenglish and
result.politics>@temppolitics and
result.special1>@tempspecial and
result.special2>@tempspecial and
result.special3>@tempspecial and
result.totalscore>@temptotal)
result.flag='录取'
else
result.flag='落选'
go

可是运行后总出现这样的提示:必须声明变量 '@tempenglish'。
请各位指教. 谢谢先!

[此贴子已经被作者于2006-8-18 9:12:37编辑过]