SELECT from Stored Proc on SQL Server
It's very convinient to read a SQL Server stored Proc result in your code for further work
To do this you should do following steps:
1. Add linked Server to the MASTER Database
use master
sp_addlinkedserver @server = 'LOCALSERVER', @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = 'your_sql_server_instance'
2. create your stored procedure , for example
use your_sql_server_instance
create proc sp_get_table @id int as
select person_id , firstname , lastname from your_table_or_view where person_id = @id
3. Write a select statement like this and test :)
use your_sql_server_instance
select * from OPENQUERY( LOCALSERVER , 'EXEC your_sql_server_instance..sp_get_table 2112')
1. Add linked Server to the MASTER Database
use master
sp_addlinkedserver @server = 'LOCALSERVER', @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = 'your_sql_server_instance'
2. create your stored procedure , for example
use your_sql_server_instance
create proc sp_get_table @id int as
select person_id , firstname , lastname from your_table_or_view where person_id = @id
3. Write a select statement like this and test :)
use your_sql_server_instance
select * from OPENQUERY( LOCALSERVER , 'EXEC your_sql_server_instance..sp_get_table 2112')
Comments
Write the first comment
Leave a trace
Post being viewed right now
