This blog shows how to use insert query with stored procedure result. Using the result set of stored procedure the insert query inserts the data to the table
Syntax:
INSERT into table
( Column_list )
Exec Storedprocedurename
Example:
Insert into emptable
(Empname, Empid)
Exec usp_getempdetails
Note: stored procedure should return the same columns
SQL Server Transact Basic to Expert - Insert Query with data from Storedprocedure
SQL Server Transact Basic to Expert - Insert Query with data from Storedprocedure
Join the conversation! Your thoughts help the community grow.