Select from stored procedure

,

The script assumes thet You use Windows Authentication otherwise You will have to modify connection string. And as it has been already mentioned in the description this is a dirty trick and it is not recomended to use in the production databases, however it may be found useful for personal purposes.

Of course if the procedure does not return any recordset You will receive an error message.

use AdventureWorks2000
go

if exists(select * from sysobjects where id = object_id('dbo.proc_simple') and type = 'P')
	drop procedure dbo.proc_simple
go

create procedure dbo.proc_simple
as
begin
	select LocationId, [Name], rowguid from dbo.Location
end
go

select * from openrowset('SQLOLEDB', 'Trusted_Connection=Yes;Server=(local);Database=AdventureWorks2000', 'exec dbo.proc_simple')
go

Rate

4.67 (9)

Share

Share

Rate

4.67 (9)