Storing a stored procedure output into a table - Hallo there Sarah Server reader, this time we will talk about Storing a stored procedure output into a table, We have prepared this article for you, hope you enjoy this Guide, Happy reading.

Title : Storing a stored procedure output into a table
link : Storing a stored procedure output into a table

Storing a stored procedure output into a table

We can use proxy tables to store the output of a procedure into a table. This requires CIS to be enabled on your system


1> create existing table mytable ( LOGIN varchar(20), ALIASEDTO varchar(20),DATABASENAME varchar(20), ALIASUSER varchar(20) )
2> external procedure at "local.sybsystemprocs.dbo.sp_alias"
3>
1> select * from mytable
2>

This will execute the procedure and send you the result in table, which you can use in other queries.

Make sure to add a local server to the sysservers system table.

There is Storing a stored procedure output into a table

Thus article Storing a stored procedure output into a table this time, hope can give benefits to all of you. well, see you in other post.

You are reading Storing a stored procedure output into a table with link https://saraserver.blogspot.com/2010/01/storing-stored-procedure-output-into.html