Multiple resulsets

Voorbeeld Stored Procedure met multiple resultsets:

/* Test stored procedure. Returns 4 ResultSets */ 
CREATE PROCEDURE spSomeStoredProcedure 
AS 
BEGIN 
SELECT CategoryName 
FROM Categories 
ORDER BY CategoryName 
SELECT Top 10 CompanyName 
FROM Customers 
ORDER BY CompanyName 
SELECT LastName 
FROM Employees 
ORDER BY LastName 
SELECT Top 10 ProductName 
FROM Products 
ORDER BY ProductName 
END 
GO

{{opmerking.Naam}}:

{{opmerking.OpmerkingText}}

            

Saving your comment....

Naam is verplicht!
Email is verplicht!
Opmerking is verplicht!