{"id":2615,"date":"2018-03-09T11:39:19","date_gmt":"2018-03-09T08:39:19","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=2615"},"modified":"2018-03-09T11:39:19","modified_gmt":"2018-03-09T08:39:19","slug":"sql-server-view-icinde-prosedur-kullanmak","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-server-view-icinde-prosedur-kullanmak\/","title":{"rendered":"Sql Server View i\u00e7inde Prosed\u00fcr kullanmak"},"content":{"rendered":"

SELECT *
\nFROM OPENROWSET(‘SQLOLEDB’,’SQLSERVER’;’sa’;’LOGO’,
\n‘exec SQLDATASI.dbo.PROSEDURADI’) AS TABLO<\/p>\n

ilgili sorgu \u00e7al\u0131\u015fmas\u0131 i\u00e7in sql konfig\u00fcrasyonunun ayarlanmas\u0131 gerekmektedir. A\u015fa\u011f\u0131daki sorgu ile yap\u0131labilir<\/p>\n

sp_configure ‘show advanced options’, 1;
\nRECONFIGURE;
\nGO
\nsp_configure ‘Ad Hoc Distributed Queries’, 1;
\nRECONFIGURE;
\nGO<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT * FROM OPENROWSET(‘SQLOLEDB’,’SQLSERVER’;’sa’;’LOGO’, ‘exec SQLDATASI.dbo.PROSEDURADI’) AS TABLO ilgili sorgu \u00e7al\u0131\u015fmas\u0131 i\u00e7in sql konfig\u00fcrasyonunun ayarlanmas\u0131 gerekmektedir. A\u015fa\u011f\u0131daki sorgu ile yap\u0131labilir sp_configure ‘show advanced options’, 1; RECONFIGURE; GO sp_configure ‘Ad Hoc Distributed Queries’, 1; RECONFIGURE; GO<\/p>\n","protected":false},"author":4,"featured_media":1752,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[94,89,96,90,93,92,95,88,91],"class_list":["post-2615","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server-tsql","tag-ad-hoc-distributed-queries","tag-mssql","tag-mssqlserver","tag-procedure","tag-reconfigure","tag-select","tag-show-advanced-options","tag-sql","tag-view"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=2615"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2615\/revisions"}],"predecessor-version":[{"id":2616,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2615\/revisions\/2616"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1752"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=2615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=2615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=2615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}