Answers for "How SQL stored procedure return multiple table"

SQL
3

how to return multiple values from stored procedure in sql server

CREATE PROC myproc AS 
BEGIN
     SELECT name FROM SYSOBJECTS
END
go

DECLARE @t TABLE (name varchar(100))
INSERT @t (name)
exec myproc
Posted by: Guest on August-30-2021

Code answers related to "How SQL stored procedure return multiple table"

Code answers related to "SQL"

Browse Popular Code Answers by Language