Answers for "using stored procedure in select statement"

stored procedure that selects in to a table

Declare @T Table ([column definitions here])
Insert @T Exec storedProcname params 
Select * from @T Where ...

Posted by: Guest on September-30-2021

create select stored procedure in sql server

CREATE PROCEDURE sp_getRaces
AS
BEGIN 
SELECT * FROM dbo.Races
END ;

Posted by: Guest on November-09-2020

Code answers related to "using stored procedure in select statement"