{"id":35,"date":"2015-08-14T10:50:40","date_gmt":"2015-08-14T10:50:40","guid":{"rendered":"http:\/\/uysalyilmaz.com\/wordpress\/?p=35"},"modified":"2015-08-14T10:50:40","modified_gmt":"2015-08-14T10:50:40","slug":"sql-ve-xml","status":"publish","type":"post","link":"http:\/\/uysalyilmaz.com\/index.php\/2015\/08\/14\/sql-ve-xml\/","title":{"rendered":"SQL ve XML"},"content":{"rendered":"<pre class=\"lang:tsql decode:true  \">DECLARE @XML XML='&lt;IDLIST&gt;&lt;ID VALUE=\"00000000-0000-0000-0000-000000000000\"\/&gt;&lt;\/IDLIST&gt;'\r\n\r\nDECLARE @docHandle INT\r\nCREATE TABLE #tmp\r\n(\r\nID UNIQUEIDENTIFIER\u00a0\r\n)\r\nEXEC sp_xml_preparedocument @docHandle OUTPUT, @XML\r\n\r\nINSERT INTO #tmp\r\nSELECT \u00a0*\r\nFROM OPENXML (@docHandle, '\/IDLIST\/ID', 1) WITH(VALUE UNIQUEIDENTIFIER)\r\nEXEC sp_xml_removedocument @docHandle<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DECLARE @XML XML='&lt;IDLIST&gt;&lt;ID VALUE=&#8221;00000000-0000-0000-0000-000000000000&#8243;\/&gt;&lt;\/IDLIST&gt;&#8217; DECLARE @docHandle INT CREATE TABLE #tmp ( ID UNIQUEIDENTIFIER\u00a0 ) EXEC sp_xml_preparedocument @docHandle OUTPUT, @XML INSERT INTO #tmp SELECT \u00a0* FROM OPENXML (@docHandle, &#8216;\/IDLIST\/ID&#8217;, 1) WITH(VALUE UNIQUEIDENTIFIER) EXEC sp_xml_removedocument @docHandle &nbsp;<\/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":[12],"class_list":["post-35","post","type-post","status-publish","format-standard","hentry","category-t-sql","tag-xml"],"_links":{"self":[{"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/posts\/35","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/comments?post=35"}],"version-history":[{"count":2,"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/posts\/35\/revisions"}],"predecessor-version":[{"id":38,"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/posts\/35\/revisions\/38"}],"wp:attachment":[{"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/categories?post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/uysalyilmaz.com\/index.php\/wp-json\/wp\/v2\/tags?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}