存储过程话题,zengzhi318 (zengzhi) 请进
看到这个代码,顺手贴出来。如此的stored procedure可以返回多个结果集
CREATE PROCEDURE dbo.TestData AS
SELECT title_id as Title_ID, title as Title, type as Type,
price as Price, notes as Notes,
CAST(pubdate as varchar) as Publication
FROM Titles
SELECT *
FROM VwAuthors
WHERE exists (Select * from Titles where au_id = VwAuthors.au_id)
ORDER BY title_id
SELECT *
FROM VwSales
WHERE exists (Select * from Titles where title_id = VwSales.title_id)