1、首先set @var = select a from AAA where a='123456'是不对的，应该：
select @var = a from AAA where a='123456'
或者
set @var = (select a from AAA where a='123456')多个可以：
select @a=a,@b=b,@c=c from AAA where b='999' and a='123456'2、没明白你的说法，好像把存储过程和界面的放在一起说了。
应该是用select * from AAA where c='147' and e='258' 返回记录集，在客户端处理。
select @var = a from AAA where a='123456'
或者
set @var = (select a from AAA where a='123456')多个可以：
select @a=a,@b=b,@c=c from AAA where b='999' and a='123456'2、没明白你的说法，好像把存储过程和界面的放在一起说了。
应该是用select * from AAA where c='147' and e='258' 返回记录集，在客户端处理。
declare mycur cursor
for
select * from AAA where c='147' and e='258'open mycurfetch next from mycur
while @@fetch_status=0
fetch next from mucur