查询与存储过程
一个存储过程View_RoomList
CREATE PROCEDURE View_RoomList
AS
SELECT TblRoom.*, TblHotel.*
FROM TblRoom INNER JOIN TblHotel ON TblRoom.HotelId=TblHotel.Hotelid;
GO
------------------------------------------------------
我想在一个查询语句里调用该存储过程 请问怎么实现
比如
Select* from EXECUTE('View_RoomList')