尝试将您的SP更改为：

Try changing your SP to something like:

select 'Dear Students HIMT Hotel Accommodation is' +  Hotelname,Phoneno,Roomrate + ' by marine' from Tb_Accommodation 
where Active!='D' and description = @Keyword

你想要多个返回值但是你的SP第一部分，而@val只包含一个一组值，你只得到一个回报集。



在上面，在返回值之间插入你想要的任何中间字符串。

You want multiple return values but your SP first part, with @val only contains one set of values and you only get one return set.

In the above, put in whatever intervening strings you wish between the return values.