In SQL Database, To insert into table from stored procedure you need to create a table with fields and data types which comes as a result of executing Stored Procedure.
INSERT INTO Employee (EmpId)
EXEC Proc_InsertEmployeeId
GO
You have successfully learnt how to insert into table from the store procedure.
Check this post to read how to Insert from one table to another Table.
1. Create Table
CREATE TABLE Employee (EmpId INT)
2. Run Execute Stored Procedure with Insert into above it
EXEC Proc_InsertEmployeeId
GO
You have successfully learnt how to insert into table from the store procedure.
Check this post to read how to Insert from one table to another Table.
No comments:
Post a Comment