{"id":99,"date":"2010-12-09T09:38:19","date_gmt":"2010-12-09T07:38:19","guid":{"rendered":"http:\/\/www.gerst-it.com\/blog\/?p=99"},"modified":"2010-12-30T11:47:26","modified_gmt":"2010-12-30T09:47:26","slug":"convert-stored-procedure-to-view","status":"publish","type":"post","link":"https:\/\/blog.gerst-it.com\/?p=99","title":{"rendered":"Convert Stored Procedure To View"},"content":{"rendered":"<p><em>1.<\/em> Stored Procedure auf dem Sql Server ausf\u00fchren und Zugriff auf OpenRowSet gew\u00e4hre<\/p>\n<p><code><em>=============================================<br \/>\n-- Author: Gerst, Daniel<br \/>\n-- Create date: 08.12.2010<br \/>\n-- Description: Converts a stored procedure to<br \/>\n-- a view.<br \/>\n-- =============================================<\/em><\/p>\n<p><em>ALTER PROCEDURE dbo.ConvertStoredProcedureToView<br \/>\n@SpName varchar(MAX),<br \/>\n@ViewName varchar(MAX)<br \/>\nAS<br \/>\nBEGIN<br \/>\nDECLARE<br \/>\n@SqlStatement nvarchar(MAX)<\/em><\/p>\n<p><em>SET NOCOUNT OFF<\/em><\/p>\n<p><em>SET @SqlStatement = N'CREATE VIEW ' + @ViewName +<br \/>\nN' AS SELECT * FROM ' + 'OPENROWSET ( ' + '''' + 'SQLOLEDB' + '''' + ',' +<br \/>\n'''' + 'SERVER=.;Trusted_Connection=yes' + '''' + ',' + '''' +<br \/>\n'SET FMTONLY OFF EXEC ' + @SpName + '''' + ')'<\/em><\/p>\n<p><em>EXEC sp_executesql @SqlStatement<\/em><\/p>\n<p><em>SET NOCOUNT ON<br \/>\nEND<\/em><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Stored Procedure auf dem Sql Server ausf\u00fchren und Zugriff auf OpenRowSet gew\u00e4hre ============================================= &#8212; Author: Gerst, Daniel &#8212; Create date: 08.12.2010 &#8212; Description: Converts a stored procedure to &#8212; a view. &#8212; ============================================= ALTER PROCEDURE dbo.ConvertStoredProcedureToView @SpName varchar(MAX), @ViewName varchar(MAX) AS BEGIN DECLARE @SqlStatement nvarchar(MAX) SET NOCOUNT OFF SET @SqlStatement = N&#8217;CREATE VIEW &#8218; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server"],"_links":{"self":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":2,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":110,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions\/110"}],"wp:attachment":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}