{"id":9,"date":"2020-06-02T14:37:03","date_gmt":"2020-06-02T14:37:03","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=9"},"modified":"2020-06-02T14:37:03","modified_gmt":"2020-06-02T14:37:03","slug":"is-not-a-valid-identifier-hatasi","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/is-not-a-valid-identifier-hatasi\/","title":{"rendered":"is not a valid identifier Hatas\u0131"},"content":{"rendered":"\n<p>SQL taraf\u0131nda \u00f6zellikle de bir sorgu yarat\u0131rken yani metinsel olarak olu\u015fturulken nadiren de olsa bu hatay\u0131 alabilirsiniz. Bunun bir ka\u00e7 nedeni var asl\u0131nda temel nedeni karaktersel olarak sizin yazd\u0131\u011f\u0131n\u0131z sorgunun \u00e7al\u0131\u015ft\u0131\u011f\u0131 server ile olu\u015fturdu\u011funuz metinsel sql i\u00e7eri\u011finin tam olarak anla\u015famamas\u0131.<\/p>\n\n\n\n<p>Bununda \u00e7\u00f6z\u00fcm\u00fc asl\u0131nda son derece basit bir komut ile sql string ifadesini \u00e7al\u0131\u015ft\u0131rmak. A\u015fa\u011f\u0131da da g\u00f6rece\u011finiz gibi e\u011fer EXEC komutunu \u201c<strong>sp_executesql<\/strong>\u201d ile birlikte verirseniz sorunun \u00e7\u00f6z\u00fcld\u00fc\u011f\u00fcn\u00fc g\u00f6receksiniz.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSET @sqlString = 'UPDATE #tmp_expt SET ' +\n'IsExpt = 0 ' +\n'WHERE ListId = ''' + @ListId + ''' AND (SELECT COUNT(1) FROM &#x5B;i3_dialer].&#x5B;dbo].&#x5B;' + @CampaignName + '] AS cal WITH(NOLOCK) ' +\n'WHERE cal.ListID = ''' + @ListId + ''' AND (cal.STATUS IN (''C'',''I'',''O'',''S'',''R'') OR cal.STATUS IS NULL)) &gt; 0'\nEXEC sp_executesql @sqlString\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>SQL taraf\u0131nda \u00f6zellikle de bir sorgu yarat\u0131rken yani metinsel olarak olu\u015fturulken nadiren de olsa bu hatay\u0131 alabilirsiniz. Bunun bir ka\u00e7 nedeni var asl\u0131nda temel nedeni karaktersel olarak sizin yazd\u0131\u011f\u0131n\u0131z sorgunun \u00e7al\u0131\u015ft\u0131\u011f\u0131 server ile olu\u015fturdu\u011funuz metinsel sql i\u00e7eri\u011finin tam olarak anla\u015famamas\u0131. Bununda \u00e7\u00f6z\u00fcm\u00fc asl\u0131nda son derece basit bir komut ile sql&#8230; <a class=\"continue-reading-link\" href=\"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/is-not-a-valid-identifier-hatasi\/\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":10,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[2],"class_list":["post-9","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql"],"_links":{"self":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":2,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"predecessor-version":[{"id":21,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/9\/revisions\/21"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media\/10"}],"wp:attachment":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}