{"id":1891,"date":"2023-04-04T00:05:52","date_gmt":"2023-04-03T21:05:52","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1891"},"modified":"2023-04-04T00:05:52","modified_gmt":"2023-04-03T21:05:52","slug":"t-sql-ile-merkez-bankasi-doviz-kurlari-getirme","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/t-sql-ile-merkez-bankasi-doviz-kurlari-getirme\/","title":{"rendered":"T-SQL \u0130le Merkez Bankas\u0131 D\u00f6viz Kurlar\u0131 Getirme"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\nCREATE PROCEDURE SP_MBK_EXCHANGE_RATE\nAS\nBEGIN\nDECLARE @URL AS VARCHAR(250) = 'https:\/\/www.tcmb.gov.tr\/kurlar\/today.xml',\n\t\t\t@OBJ AS INT,\n\t\t\t@RESULT AS INT\n\n\tEXEC @RESULT = SP_OACREATE 'MSXML2.XMLHttp', @OBJ OUT \n\tEXEC @RESULT = SP_OAMethod @OBJ, 'open', NULL,'GET', @URL, false\n\tEXEC @RESULT = SP_OAMethod @OBJ,SEND,NULL,''\n\n\tCREATE TABLE #TEMPXML (STRXML VARCHAR(MAX))\n\tINSERT INTO #TEMPXML (STRXML) EXEC @RESULT = SP_OAGetProperty @OBJ,'ResponseXML.xml'\n\n\tDECLARE @XML AS XML\n\tSELECT @XML = STRXML FROM #TEMPXML\n\t--SELECT @XML\n\tDROP TABLE #TEMPXML\n\n\tDECLARE @HDOC AS INT\n\tEXEC SP_XML_PREPAREDOCUMENT @HDOC OUTPUT,@XML\n\n\t-- T\u00fcm veriler siliniyor\n\tDELETE FROM dbMEDIUM.dbo.MBK_EXCHANGE_RATE \n\n\t-- Veriler yeniden ekleniyor\n\tINSERT dbMEDIUM.dbo.MBK_EXCHANGE_RATE\n\tSELECT * FROM OPENXML(@HDOC,'Tarih_Date\/Currency')\n\tWITH\n\t(\n\t\tUnit VARCHAR(50) 'Unit',\n\t\tIsim VARCHAR(50) 'Isim', \n\t\tCurrencyName VARCHAR(50) 'CurrencyName', \n\t\tForexBuying FLOAT 'ForexBuying', \n\t\tForexSelling FLOAT 'ForexSelling', \n\t\tBanknoteBuying FLOAT 'BanknoteBuying', \n\t\tBanknoteSelling FLOAT 'BanknoteSelling'\n\t)\n\nEND\n\t<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":1817,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1096],"tags":[1250,1249,378,256,1248,485],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1891"}],"collection":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/comments?post=1891"}],"version-history":[{"count":1,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1891\/revisions"}],"predecessor-version":[{"id":1892,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1891\/revisions\/1892"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media\/1817"}],"wp:attachment":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media?parent=1891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}