SQL’\u0130 SEVENLERE HAZIRLADI\u011eIM FONKS\u0130ON L\u0130STES\u0130<\/p>\n
SQL KOMUTLARI<\/strong><\/p>\n CREATE TABLE <\/strong>:Yeni bir tablonun, alanlar\u0131n\u0131n ve indexlerinin yarat\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n <\/p>\n CREATE INDEX <\/strong>:Belirlenen bir tablo i\u00e7in (index) yarat\u0131lmas\u0131n\u0131 sa\u011flar<\/p>\n DROP TABLE <\/strong>:Belirtilen tablonun ve dizinlerin veri taban\u00fdndan silinmesini sa\u011flar.<\/p>\n ALTER TABLE <\/strong>:Tabloya yeni alanlar\u0131n ilavesini veya alan tan\u0131mlamas\u0131n\u0131n de\u011fi\u015fitilmesini sa\u011flar.<\/p>\n ————————-<\/p>\n SELECT<\/strong>:Belirlenen bir \u00f6l\u00e7\u00fcte g\u00f6re tablo i\u00e7erisindeki kay\u0131tlar\u0131n se\u00e7ilmesini sa\u011flar.<\/p>\n INSERT <\/strong>:Tablo i\u00e7inde yer alan kay\u0131tlara bir yenisinin eklemesini sa\u011flarlar.<\/p>\n UPDATE<\/strong>:Tablonun belirlenen bir kayd\u0131n\u0131n alanlar\u0131n\u0131n g\u00fcncellenmesini sa\u011flar.<\/p>\n DELETE<\/strong>:Tablodan belirlenen kay\u0131tlar\u0131n silinmesine neden olur.<\/p>\n ——————–<\/p>\n FROM <\/strong>:Sorgulaman\u0131n hangi tablodan yap\u0131laca\u011f\u0131n\u0131 tan\u0131mlar.<\/p>\n WHERE <\/strong>:Sorgulama esnas\u0131nda kullan\u0131lacak k\u0131stas\u0131 tan\u0131mlar.<\/p>\n GROUP BY <\/strong>:Kay\u0131tlar\u0131 belirlenen alana g\u00f6re gruplar.<\/p>\n HAVING <\/strong>:Her bir grubun uymas\u0131 gereken \u00f6l\u00e7\u00fct\u00fc tan\u0131mlar.<\/p>\n CONSTRAINT<\/strong>:Dizin tan\u0131mlamas\u0131n\u0131 ve bir di\u011fer tablo ile ileti\u015fim kurulmas\u0131n\u0131 sa\u011flar.<\/p>\n —————–<\/p>\n AND <\/strong>:Se\u00e7me i\u015fleminin iki ayr\u0131 \u00f6l\u00e7\u00fct\u00fcn birlikte ger\u00e7ekle\u015fmesi durumunda yap\u0131lacakt\u0131r.<\/p>\n ALL :<\/strong>Sorguda istenilen de\u011ferin hepsini getir<\/p>\n ANY :<\/strong>Sorguda istenilen de\u011ferin herhangi birini getirmek i\u00e7in<\/p>\n OR <\/strong>:\u00d6l\u00e7\u00fctlerden biri ger\u00e7ekle\u015fti\u011finde belirtilen se\u00e7me i\u015flemi yap\u0131lacakt\u0131r.<\/p>\n NOT <\/strong>:\u00d6l\u00e7\u00fct\u00fcn ger\u00e7ekle\u015fmemesi durumunda yap\u0131lacak se\u00e7me i\u015flemini tan\u0131mlar.<\/p>\n EXCEPT :<\/strong>\u0130ki tablo yada iki sorguyu kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n EXISTS :<\/strong> \u0130ki tablo yada sorgu aras\u0131ndaki mevcut olanlar\u0131 bulmak i\u00e7in kulan\u0131l\u0131r.<\/p>\n NOT EXISTS<\/strong>: \u0130ki tablo yada sorgu aras\u0131ndaki mevcut olmayan\u0131 bulmak i\u00e7in kulan\u0131l\u0131r.<\/p>\n ORDER BY :<\/strong>Ilgili alan\u0131 s\u0131ralamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n ORDER BY DESC:<\/strong>Tablodan se\u00e7tigimiz kayitlari son kay\u0131t s\u0131ras\u0131na g\u00f6re siralamak i\u00e7in kullanilir.<\/p>\n ORDER BY ASC:<\/strong>Tablodan se\u00e7tigimiz kayitlari alfabetik siralamak i\u00e7in kullanilir.<\/p>\n REPLACE:<\/strong>\u0130lgili kolondaki istenmeyen karakterlerin silinmesi ve de\u011fi\u015ftirilmesini sa\u011flar<\/p>\n JUSTIFY<\/strong>:Se\u00e7ilen metni istenilen uzunlukta yazar. Metinde olu\u015fan bo\u015fluklar\u0131 istenen karakterle doldurur…<\/p>\n DISTINCT:<\/strong>Birbirinin ayni olan satirlarin listelenmemesi i\u00e7in bu ifade kullanilir<\/p>\n <\/p>\n JOIN :<\/strong>Birden fazla tabloyu ili\u015fkilendirmek i\u00e7in kullan\u0131l\u0131r<\/p>\n INTERSECT<\/strong>: Her iki tabloda yada sorguda kesi\u015fen alanlar\u0131 listeler.<\/p>\n SAVE TO TEMP():<\/strong>istenilen alan\u0131bir tablo i\u00e7inde sakla.<\/p>\n KEEP():<\/strong>Tablolarda de\u011fi\u015fkil yapmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n UNIQUE : <\/em><\/strong>Bir tablo,se\u00e7ilen bir sut\u00fcna (alana) g\u00f6re indekslenirken , indeksleme alan\u0131 olarak se\u00e7ilen sut\u00fcndaki verilerin tekrarlanmamas\u0131n\u0131 sa\u011flar.<\/p>\n MODOFY :<\/strong>Onarmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n RENAME<\/strong>: Yeni isim vermek i\u00e7in kullan\u0131l\u0131r.<\/p>\n WITH CHECK OPTION<\/strong>: Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flar<\/p>\n CREATE V\u0130EW :<\/em><\/strong>Veri g\u00fcvenli\u011fi i\u00e7in yedek al\u0131n\u0131r.<\/p>\n UNION ve UNION ALL :<\/strong>Join methoduna benzer ama sadece ayn\u0131 kolonlara sahip tablolar\u0131 birbirine ba\u011flar.<\/p>\n ALIAS:<\/strong>Genelde tablonun veya kolonun ad\u0131n\u0131 ba\u015fka bir \u015feymi\u015f gibi de\u011fi\u015firebiliriz.<\/p>\n MINUS<\/strong>: Birinci k\u00fcmede olan, ikinci k\u00fcmede olmayan kay\u0131tlar\u0131 se\u00e7er<\/p>\n INTERSECT<\/strong>:Sadece her iki ko\u015fulada uyan kay\u0131tlar\u0131 se\u00e7er<\/p>\n IS NULL<\/strong>:Null (yokluk) de\u011ferine sahip olanlar\u0131 tan\u0131mlar<\/p>\n IS NOT NULL<\/strong>Null de\u011ferine sahip olmayanlar\u0131 tan\u0131mlar<\/p>\n <\/p>\n + – \/ * + (Toplama) – (\u00c7\u0131karma) \/ (B\u00f6lme) * (\u00c7arpma)<\/p>\n ( ) \u0130\u015flemleri grupland\u0131rma ve i\u015flem \u00f6nceli\u011fi belirleme<\/p>\n < …den daha k\u00fc\u00e7\u00fck<\/p>\n > …den daha b\u00fcy\u00fck<\/p>\n = E\u015fit<\/p>\n <= K\u00fc\u00e7\u00fck veya e\u015fit<\/p>\n >= B\u00fcy\u00fck veya e\u015fit<\/p>\n <> E\u015fit de\u011fil<\/p>\n != E\u015fit de\u011fil<\/p>\n ^=E\u015fit de\u011fil<\/p>\n !< …den k\u00fc\u00e7\u00fck de\u011fil<\/p>\n !> …den b\u00fcy\u00fck de\u011fil<\/p>\n ———————————————<\/p>\n BETWEEN : \u0130<\/strong>ki de\u011fer aras\u0131ndaki de\u011feri belirler.<\/p>\n LIKE :<\/strong>Belirlenen iki kay\u0131da uygun olanlar\u0131 tan\u0131mlar.<\/p>\n IN :<\/strong>Bir veri taban\u0131 i\u00e7indeki kay\u0131tlar\u0131 belirler.<\/p>\n AVG(kolon ):<\/strong>girilen kolondaki say\u0131lar\u0131n aritmetik ortalama degerini geri yollar SUBSTR:<\/strong>Belirlenen alandaki de\u011ferin istenilen karakterleri se\u00e7ilebilir<\/p>\n SQRT:<\/strong>Belirlenen alandaki de\u011ferin karak\u00f6k\u00fcn\u00fcn al\u0131nmas\u0131n\u0131 sa\u011flar<\/p>\n D\u0130\u011eER FONKS\u0130YONLAR<\/strong><\/p>\n ADD FILE<\/strong>:Mevcut database e dosya eklemek i\u00e7in kullan\u00fdl\u00fdr..<\/p>\n REMOVE FILE<\/strong>:Mevcut database i\u00e7erisindeki dosyalar\u00fd ortadan kald\u00fdrmak i\u00e7in kullan\u0131l\u0131r..<\/p>\n MODIFY FILE<\/strong>: Mevcut database dosyalar\u00fdndan birinin \u00f6zelliklerini de\u00f0i\u00fetirmek i\u00e7in kullan\u00fdl\u00fdr<\/p>\n SUBSTRING<\/strong>:Bir string ifadenin belli bir k\u00fdsm\u00fdn\u00fd geri d\u00f6nd\u00fcr\u00fcr<\/p>\n LOVER<\/strong>: Bir string ifadeyi k\u00fc\u00e7\u00fck harfli hale getirir..<\/p>\n UPPER<\/strong>: bir string ifadeyi b\u00fcy\u00fck harfli hale getirir..<\/p>\n REVENSE<\/strong>: Parametre olarak ald\u00fd\u00f0\u00fd string ifadeyi ters \u00e7evirir..<\/p>\n SPACE:<\/strong>istenilen say\u00fdda bo\u00feluk b\u00fdrak\u00fdr..<\/p>\n DATEADD<\/strong>: Parametre olarak girilen tarihe day\/month\/year gibi tarih ifadeleri ekler ve yeni tarihi verir<\/p>\n DATEDIFF(d,birinciTarih,ikinciTarih ):V<\/strong>erilen iki tarih aras\u0131ndaki fark\u0131 day\/month\/year cinsinden getirir..<\/p>\n DATEPART (<\/strong>tarihpar\u00e7as\u0131<\/em>,<\/strong>tarih<\/em>)<\/strong>:Belirtilen tarihin istenen par\u00e7as\u0131na kar\u015f\u0131l\u0131k olarak bir tamsay\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n DATANAME<\/strong>: \u0130stenilen alan\u0131 string olarak getirmektedir.<\/p>\n GETDATE<\/strong>: Tarih bilgisini getirmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n DAY(<\/strong>tarih<\/em><\/strong>)<\/strong>:<\/strong>Bir tarih bilgisinin g\u00fcn k\u0131sm\u0131n\u0131 verir.<\/p>\n MONTH(<\/strong>tarih<\/em><\/strong>)<\/strong>: Bir tarih bilgisinin ay k\u0131sm\u0131n\u0131 verir.<\/p>\n YEAR(<\/strong>tarih<\/em><\/strong>)<\/strong>:<\/strong>Bir tarih bilgisinin y\u0131l k\u0131sm\u0131n\u0131 verir.<\/p>\n UCASE(c ):<\/strong>bolgedeki karakterlerin hepsini buyuk yapar LEN ( karakter dize<\/em>) :<\/strong>Dize verinin uzunlu\u011funu d\u00f6nd\u00fcr\u00fcr.<\/p>\n INSTR(c ):<\/strong>yaz\u0131 alan\u0131ndan karakterleri gosterir RIGHT(c,number_of_char ):<\/strong>text alan\u0131n\u0131n girilen say\u0131ya kadar olan k\u0131sm\u0131n\u0131 yollar (sagdan sayar ) LTRIM(<\/strong>karakter dize<\/em><\/strong>) :<\/strong> \u00d6n\u00fcndeki bo\u015flu\u011fu silmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n RTRIM ( karakter dize<\/em>):<\/strong>Karakter dizesinin arkas\u0131ndaki bo\u015fluklar\u0131 kald\u0131r\u0131r.<\/p>\n STUFF ( karaker dize<\/em>, ba\u015flang\u0131\u00e7<\/em>, uzunluk<\/em>, karakter dize<\/em>) :<\/strong>Belirtilen uzunluktaki karakterleri siler ve yerine belirtilen di\u011fer karakterleri ekler.<\/p>\n CHARINDEX ( ifade1<\/em>, ifade2<\/em>[ , ba\u015flang\u0131\u00e7 konumu<\/em>] ) :<\/strong>Bir karakter dize i\u00e7inde belirtilen bir ifadenin (karakterin) ba\u015flang\u0131\u00e7 konumunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n ASCII ( karakter ifade<\/em>) :<\/strong>Bir karakter ifadenin en soldaki de\u011ferinin ASCII kodunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" SQL’\u0130 SEVENLERE HAZIRLADI\u011eIM FONKS\u0130ON L\u0130STES\u0130 SQL KOMUTLARI CREATE TABLE :Yeni bir tablonun, alanlar\u0131n\u0131n ve indexlerinin yarat\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-294","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\/294","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=294"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/294\/revisions"}],"predecessor-version":[{"id":327,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/294\/revisions\/327"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nBINARY_CHECKSUM:<\/strong> tablonun verilen sat\u0131r\u0131ndaki ikilik tabandaki checksum degerini yollar
\nCHECKSUM:<\/strong> tablonun verilen sat\u0131r\u0131ndaki checksum degerini yollar
\nCHECKSUM_AGG:<\/strong> bo\u015f degerler haricindeki verilerin checksum degerini yollar
\nCOUNT(kolon ):<\/strong> Bo\u015f degerler haric, girilen kolondaki sat\u0131r say\u0131s\u0131n\u0131 yollar
\nCOUNT(* ):<\/strong> Verilen tablodaki sat\u0131r say\u0131s\u0131n\u0131 yollar
\nCOUNT(DISTINCT kolon ):<\/strong> Verilen tablodaki sat\u0131r say\u0131s\u0131n\u0131 yollar, fakat cift veri bulunan sat\u0131rlar\u0131 bir defa sayar
\nFIRST(kolon ):<\/strong> girilen kolondaki ilk degeri yollar
\nLAST(kolon ):<\/strong> girilen kolondaki son degeri yollar
\nMAX(kolon ):<\/strong> girilen kolondaki en yuksek degeri yollar
\nMIN(kolon ):<\/strong> girilen kolondaki en dusuk degeri yollar
\nSTDEV(kolon ):<\/strong> girilen kolondaki basit istatiksel standard sapma degerini yollar
\nSTDEVP(kolon ):<\/strong> girilen kolondaki n\u00fcfus istatiksel standard sapma degerini yollar
\nSUM(kolon ):<\/strong> girilen kolondaki say\u0131lar\u0131n toplam\u0131n\u0131 yollar<\/p>\n
\nLCASE(c ):<\/strong> bolgedeki karakterlerin hepsini kucuk yapar
\nMID(c,start[,end] ):<\/strong> yaz\u0131 alan\u0131ndan karakterleri cal\u0131st\u0131r\u0131r<\/p>\n
\nLEFT(c,karakterNumarasi ):<\/strong> text alan\u0131n\u0131n girilen say\u0131ya kadar olan k\u0131sm\u0131n\u0131 yollar (soldan sayar )<\/p>\n
\nROUND(c,hassasiyet ):<\/strong> say\u0131 alan\u0131n\u0131 verilen hassasiyete gore yuvarlar
\nMOD(x,y ):<\/strong> bolme i\u015fleminde kalan\u0131 gosterir (mod i\u015flemi yapar )
\nNOW( ):<\/strong> o anki sistem zaman\u0131n\u0131 gosterir
\nFORMAT(c,format ):<\/strong> alan\u0131n gosterim bi\u00e7imini degi\u015ftirir<\/p>\n