Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

Microsoft SQL Server - Returning Result Sets from Stored Procedures

You can use a standalone SELECT statement (without INTO clause, or SET expression) to return a result set from a T/SQL stored procedure.

Example (SQL Server):

CREATE PROCEDURE dbo.GetOrderInfo @data INT
  SELECT * FROM dbo.OrderInfo WHERE data = @data; 

Returning Result Sets - Differences between SQL Server and other Databases

Database Returning Result Sets
Oracle Oracle result sets - OPEN cursor statement and refcursor OUT parameter

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.