还是不行啊,我把修改后的源程序发上吧,如下:create procedure sp_GetMsg @name varchar(20)as select top 3 messageFrom,sendTime,messageTo,message,'message_send.aspx?TextBox4='+messageFrom+'&TextBox5='+messageTo as Para from message where messageTo=@name and old=0 Order by SendTime Update message Set old=1 where messageTo in(select top 3 messageTo=@name from message) and old=0
@name varchar(20)as
select top 3 messageFrom,sendTime,messageTo,message,'message_send.aspx?TextBox4='+messageFrom+'&TextBox5='+messageTo as Para
from message
where messageTo=@name and old=0
Order by SendTime
Update message
Set old=1 where messageTo in(select top 3 messageTo=@name from message)
and old=0