Question

sql执行存储过程 如何输出结果

我的SQL存储过程如下，然而我希望它最终能输出我if判断下的select语句内容，它却总是告诉我“命令已成功完成。”怎样修改才能让他输出select语句中的内容呢？
alter procedure ticket_specific_info
@userNo as varchar(20),@serviceNo as char(10)
as
begin
select @serviceNo=serviceNo from ticketInfo where userNo=@userNo
if @serviceNo ='service00002'
begin
select ticketSum*commercialPrice as '机票费用',departCity as '出发城市',arrivalCity as'到达城市',departTime as '出发时间',
arrivalTime as '到达时间',departDate as '出发日期',arrivalDate as '到达日期'
from ticketInfo ti, airlineInfo ai, userInfo ui
where ti.userNo=ui.userNo and ui.userNo=@userNo
end
else if @serviceNo ='service00001'
begin
select ticketSum*commonPrice as '机票费用',departCity as '出发城市',arrivalCity as'到达城市',departTime as '出发时间',
arrivalTime as '到达时间',departDate as '出发日期',arrivalDate as '到达日期'
from ticketInfo ti, airlineInfo ai, userInfo ui
where ti.userNo=ui.userNo and ui.userNo=@userNo
end
end

Answer 1

就是这样输出的用select就可以了，细节你在检查一下，看看是不是符合if的条件。