<\/div>\n
Merhaba,<\/p>\n
SQL Server’da yap\u0131lan i\u015flemleri fonksiyonilize etmeksizin otomatik bir \u015fekilde hesaplayabilmek i\u00e7in Computed Columns(Hesaplanm\u0131\u015f Kolonlar) dedi\u011fimiz yap\u0131lar\u0131 kullanabiliriz. <\/p>\n
Bu i\u015flem i\u00e7in a\u015fa\u011f\u0131daki yap\u0131y\u0131 inceleyiniz.<\/p>\n
\r\nCREATE TABLE ORNEKTABLO\r\n(\r\n\tSayi1 int,\r\n\tSayi2 int,\r\n\tSonuc as (Sayi1 + Sayi2)\r\n)\r\n<\/pre>\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi “Sonuc” kolonunda “as” operat\u00f6r\u00fc ile “Sayi1” ve “Sayi2” kolonlar\u0131n\u0131n toplam\u0131n\u0131 otomatik olu\u015fturuyoruz.<\/p>\n
Bu i\u015flem neticesinde tablomuz a\u015fa\u011f\u0131daki gibi bir \u00e7al\u0131\u015fma sergileyecektir.
\n<\/a><\/p>\n
G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi “Sonuc” kolonunda “Sayi1” ve “Sayi2” de\u011ferlerinin toplam\u0131n\u0131 g\u00f6rmekteyiz. Bu toplam sonucu fiziksel olarak tutulmamakta, “select” sorgusu \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131 anda ilgili de\u011ferler toplanmaktad\u0131r. E\u011fer ki Computed Columns’un fiziksel olarak tutulmas\u0131n\u0131 istiyorsan\u0131z a\u015fa\u011f\u0131daki gibi “PERSISTED” anahtar s\u00f6zc\u00fc\u011f\u00fcn\u00fc kullanmal\u0131s\u0131n\u0131z.<\/p>\n
\r\nCREATE TABLE ORNEKTABLO\r\n(\r\n\tSayi1 int,\r\n\tSayi2 int,\r\n\tSonuc as (Sayi1 + Sayi2) PERSISTED \r\n)\r\n<\/pre>\nE\u011fer ki fiziksel bir kay\u0131t kullanmayacaksan\u0131z Computed Columns yerine “select” sorgusunda ilgili i\u015flemleri ger\u00e7ekle\u015ftirmeniz kan\u0131mca daha performansl\u0131 ve maliyetli olacakt\u0131r.<\/p>\n
Faydalanman\u0131z dile\u011fiyle…
\n\u0130yi \u00e7al\u0131\u015fmalar…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, SQL Server’da yap\u0131lan i\u015flemleri fonksiyonilize etmeksizin otomatik bir \u015fekilde hesaplayabilmek i\u00e7in Computed Columns(Hesaplanm\u0131\u015f Kolonlar) dedi\u011fimiz yap\u0131lar\u0131 kullanabiliriz. Bu i\u015flem i\u00e7in a\u015fa\u011f\u0131daki yap\u0131y\u0131 inceleyiniz. CREATE TABLE ORNEKTABLO ( Sayi1 int, Sayi2 int, Sonuc as...<\/p>\n","protected":false},"author":1,"featured_media":3415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1082,22],"tags":[823,1425,1426,1427],"class_list":["post-4949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","category-veritabani","tag-as","tag-computed-columns","tag-hesaplanmis-kolonlar","tag-persisted"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/4949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=4949"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/4949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3415"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=4949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=4949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=4949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}