Convert Stored Procedure To View
1. Stored Procedure auf dem Sql Server ausführen und Zugriff auf OpenRowSet gewähre
=============================================
-- Author: Gerst, Daniel
-- Create date: 08.12.2010
-- Description: Converts a stored procedure to
-- a view.
-- =============================================
ALTER PROCEDURE dbo.ConvertStoredProcedureToView
@SpName varchar(MAX),
@ViewName varchar(MAX)
AS
BEGIN
DECLARE
@SqlStatement nvarchar(MAX)
SET NOCOUNT OFF
SET @SqlStatement = N'CREATE VIEW ' + @ViewName +
N' AS SELECT * FROM ' + 'OPENROWSET ( ' + '''' + 'SQLOLEDB' + '''' + ',' +
'''' + 'SERVER=.;Trusted_Connection=yes' + '''' + ',' + '''' +
'SET FMTONLY OFF EXEC ' + @SpName + '''' + ')'
EXEC sp_executesql @SqlStatement
SET NOCOUNT ON
END
Posted: Dezember 9th, 2010 under MS Sql Server.