{"id":1087,"date":"2015-06-05T15:51:01","date_gmt":"2015-06-05T12:51:01","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=1087"},"modified":"2015-10-16T17:36:14","modified_gmt":"2015-10-16T14:36:14","slug":"sql-string-fonksiyonlari","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-string-fonksiyonlari\/","title":{"rendered":"Sql String Fonksiyonlar\u0131"},"content":{"rendered":"

\"\"<\/p>\n

Sql taraf\u0131nda i\u015fleri ne kadar iyi \u00e7\u00f6z\u00fcmlersek yaz\u0131l\u0131m dilleri traf\u0131nda kodlar o kadar sadele\u015fiyor ve olas\u0131 basit de\u011fi\u015fiklikler s\u00f6z konusu oldu\u011funda maliyeti oldukca d\u00fc\u015f\u00fcr\u00fcyor.<\/p>\n

LEFT<\/i><\/b> String ifadeden soldan verilen say\u0131 kadar\u0131n\u0131 g\u00f6sterir.
\nSELECT LEFT(‘\u015eEBNEM FERAH’,3)
\nSonu\u00e7<\/b>:\u015eEB<\/p>\n

<\/p>\n

RIGHT<\/i><\/b> Stringten sa\u011fdan verilen say\u0131 kadar\u0131n\u0131 g\u00f6sterir.
\nSELECT RIGHT(‘\u015eEBNEM FERAH’,5)
\nSonu\u00e7<\/b>:FERAH<\/p>\n

LEN<\/i><\/b> Verilen stringin karakter say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Buna bo\u015fluk karakteride dahildir.
\nSELECT LEN(‘\u015eEBNEM FERAH’)
\nSonu\u00e7<\/b>:12<\/p>\n

UPPER<\/i><\/b> K\u00fc\u00e7\u00fck harfli verilen stringi b\u00fcy\u00fck harflere \u00e7evirir.
\nSELECT UPPER(‘fatih’)
\nSonuc: FAT\u0130H<\/p>\n

LOWER<\/i><\/b> B\u00fcy\u00fck harfli verilen stringi k\u00fc\u00e7\u00fck harflere \u00e7evirir.
\nSELECT LOWER(‘FAT\u0130H’)
\nSonu\u00e7<\/b>: Fatih<\/p>\n

SUBSTRING<\/i><\/b> Verilen stringten par\u00e7a almak i\u00e7in kullan\u0131l\u0131r.
\n\u00d6rnekte verilen parametrelere g\u00f6re 2 den ba\u015flayrak 3 tane karakter al demi\u015f olduk.
\nSELECT SUBSTRING(‘FAT\u0130H’,2,3)
\nSonu\u00e7<\/b>: AT\u0130<\/p>\n

REPLACE<\/i><\/b> Verilen karakterleri biribiriyle de\u011fi\u015ftirir.
\n\u00d6rnekte MAK\u0130N\u0130ST kelimelerini P\u0130LOT olarak de\u011fi\u015ftir dedimi\u015f olduk.
\nSELECT REPLACE(‘MAK\u0130N\u0130ST AHMET’,’MAK\u0130N\u0130ST’,’P\u0130LOT’)
\nSonu\u00e7<\/b>:P\u0130LOT AHMET<\/p>\n

STUFF<\/b><\/i> 4 paremetre olarak \u00e7al\u0131\u015fan bu fonksiyon replace fonksiyonu gibi \u00e7al\u0131\u015f\u0131r ama fark olarak karakter olarak de\u011fil verilen indexlere g\u00f6re de\u011fi\u015ftirme yapar.
\nSELECT STUFF(‘Audi hh’,5,3,’TT’)
\nSonu\u00e7<\/b>:AudiTT<\/p>\n

LTRIM<\/i><\/b> Soldan bo\u015fluklar\u0131 al\u0131r.
\nSELECT LTRIM(‘ RAMBO’)
\nSonu\u00e7<\/b>:RAMBO<\/p>\n

RTRIM<\/i><\/b> Sa\u011fdan bo\u015fluklar\u0131 al\u0131r.
\nSELECT RTRIM(‘RAMBO ‘)
\nSonu\u00e7<\/b>:RAMBO<\/p>\n

REVERSE<\/b><\/i> stringi ters \u00e7evirir.
\nSELECT REVERSE(‘RAMBO’)
\nSonu\u00e7<\/b>:OBMAR<\/p>\n

QUOTENAME<\/i><\/b> Verilen string ifadeyi k\u00f6\u015feli parantez [] i\u00e7ine almay\u0131 sa\u011flar.
\nSELECT QUOTENAME (‘SELECT’)
\nSonu\u00e7<\/b>:[SELECT]<\/p>\n

REPLICATE<\/i><\/b> Verilen string ifadeyi parametre ge\u00e7ilen say\u0131 kadar tekrarlar.
\nSELECT REPLICATE(‘0’,10)
\nSonu\u00e7<\/b>:0000000000<\/p>\n","protected":false},"excerpt":{"rendered":"

Sql taraf\u0131nda i\u015fleri ne kadar iyi \u00e7\u00f6z\u00fcmlersek yaz\u0131l\u0131m dilleri traf\u0131nda kodlar o kadar sadele\u015fiyor ve olas\u0131 basit de\u011fi\u015fiklikler s\u00f6z konusu oldu\u011funda maliyeti oldukca d\u00fc\u015f\u00fcr\u00fcyor. LEFT String ifadeden soldan verilen say\u0131 kadar\u0131n\u0131 g\u00f6sterir. SELECT LEFT(‘\u015eEBNEM FERAH’,3) Sonu\u00e7:\u015eEB<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1087","post","type-post","status-publish","format-standard","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1087","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=1087"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1087\/revisions"}],"predecessor-version":[{"id":1089,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1087\/revisions\/1089"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}