Sql Server Result Set From Stored Procedure. SELECT FirstName LastName AS Full Name Education Occupation YearlyIncome Sales HireDate FROM Employee END GO. SET NOCOUNT ON-- Insert statements for procedure here.
-- SQL Stored Procedure - Insert Stored Procedure result into Temporary Table in SQL Example USE SQL Tutorial GO IF OBJECT_ID SelectStoredProcedureFirstExample P IS NOT NULL DROP PROCEDURE SelectStoredProcedureFirstExample. Can be used with multiple result sets returned by queries to change the column names and data types at runtime. This stored procedure or SP will return all customer information and related customer address detail whose phone number is given as a parameter argument to the SQL Server stored procedure.
First we will create a sample stored procedure.
Now if such a kind of operation is not allowed in SQL Server how can it be possible to use the result set from a stored procedure in a Select statement. There was a recent question asked on Stack Overflow. Of course we can use INSERT EXEC method ie INSERT INTO YourTempTable Col1 Col2 EXEC yourSP. SET NOCOUNT ON-- Insert statements for procedure here.