{"id":205,"date":"2010-08-14T23:40:42","date_gmt":"2010-08-14T21:40:42","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=205"},"modified":"2017-04-16T14:40:22","modified_gmt":"2017-04-16T12:40:22","slug":"prosedurler","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/","title":{"rendered":"Prosed\u00fcrler"},"content":{"rendered":"<p style=\"font-family: Arial, Helvetica, sans-serif;\">Northwind<\/p>\n<pre class=\"brush:sql\">-------------------PRODESURLER------------------------\r\n\r\n\/*\r\n\tStored Procedure(Sakl\u0131 yordam)\r\n\tMetot\r\n\tinsert,update vs.\r\n\tsql de saklan\u0131r\r\n\tg\u00fcvenlik\r\n\tperformans\r\n\t\tnetwork'teki veri\r\n\t\t\u00f6n belleklenmi\u015f execution plan\r\n*\/\r\n\r\n---------------procedure \u00f6rnekleri-----------------------\r\n--ddl (data definition language)\r\n-- sp ile de ba\u015flayabilir.\r\ncreate procedure up_CalisanlariGetir\r\nas\r\nselect FirstName,LastName from Employees\r\n\r\nexec up_CalisanlariGetir\r\n\r\n--yap\u0131lan proc yanl\u0131\u015f olursa alter ile d\u00fczeltilebilir.\r\n\r\n--Kategorilerin ad\u0131n\u0131 ve a\u00e7\u0131klamas\u0131n\u0131 getiren bir proc\r\ncreate procedure up_KategorileriGetir\r\nas\r\nselect CategoryName, [Description] from Categories\r\n\r\nexec up_kategorilerigetir\r\n\r\n--parametre olarak  id'si verilen m\u00fc\u015fterinin sipari\u015flerinin tarihlerimi listeleyen bir proc yazalim.\r\ncreate proc up_TarihleriGetir\r\n(\r\n\t@CustID char(5)\r\n)\r\nas\r\nselect OrderDate from Orders\r\nwhere CustomerID=@CustID\r\n\r\nexec up_TarihleriGetir 'ALFKI'\r\n\r\n--parametre olarak CategoryID ve EmployeeID de\u011ferlerini al\u0131p o kategorideki o \u00e7al\u0131\u015fan\u0131n satt\u0131\u011f\u0131 \u00fcr\u00fcnlerin ad\u0131n\u0131 ve sat\u0131lan miktarlar\u0131n\u0131 getiren proc\r\nalter proc up_UrunAdet\r\n(\r\n\t@CatID int,\r\n\t@EmpID int\r\n)\r\nas\r\nselect p.ProductName,od.Quantity\r\nfrom Products p\r\njoin [Order Details] od on p.ProductID=od.ProductID\r\njoin Orders o on o.OrderID=od.OrderID\r\nwhere p.CategoryID=@CatID and o.EmployeeID=@EmpID order by p.ProductName\r\n\r\nexec up_UrunAdet 1,1\r\n\r\n--yeni kategori ekleyen proc.\r\n--bu proc ekleyen kayd\u0131n id de\u011ferini geriye dondursun\r\n\r\ncreate proc up_KategoriEkle\r\n(\r\n\t@CatName varchar(15)\r\n)\r\nas\r\ninsert into Categories(CategoryName)\r\nvalues (@CatName)\r\n--@@identity son eklenen sat\u0131r\u0131n ID sini verir.\r\nreturn @@identity\r\n\r\n--de\u011fi\u015fken declare ile olu\u015ftururlur\r\ndeclare @id int\r\nexec @id=up_KategoriEkle 'Yeni kategori'\r\nselect @id as 'Eklenen Sat\u0131r\u0131n ID'\r\n\r\n--calisanin ad\u0131n\u0131 ve soyad\u0131n\u0131 ekleyecek \u015fekilde ve eklenen kayd\u0131n id sini d\u00f6nd\u00fcrecek bir proc.\r\ncreate proc up_CalisanEkle\r\n(\r\n\t@EmpFirst nvarchar(10),\r\n\t@EmpLast nvarchar(20)\r\n)\r\nas\r\ninsert into Employees(FirstName,LastName) values (@EmpFirst,@EmpLast)\r\nreturn @@identity\r\n\r\n--ekleme i\u015flemi\r\ndeclare @id int\r\nexec @id=up_CalisanEkle 'Murat','ALTINI\u015eIK'\r\nselect @id\r\n\r\n--output parametleri proc bu parametrede sat\u0131lan \u00fcr\u00fcn order detailse eklendikten sonra prodct taplosunda yeni de\u011ferler girer\r\ncreate proc up_SatisTap\r\n(\r\n\t@OrderID int,\r\n\t@ProductID int,\r\n\t@Quantity smallint,\r\n\t@UnitPrice money,\r\n\t@Discount real,\r\n\t@KalanMiktar smallint out,\r\n\t@BasariliMi bit out\r\n)\r\nas\r\nbegin try\r\n\tinsert into [Order Details] values (@OrderID,@ProductID,@UnitPrice,@Quantity,@Discount)\r\n\tupdate Products set UnitsInStock=UnitsInStock-@Quantity where ProductID=@ProductID\tselect @KalanMiktar=UnitsInStock from Products\r\n\twhere ProductID=@ProductID\r\n\tset @BasariliMi=1\r\nend try\r\nbegin catch\r\n\tset @BasariliMi=0\r\nend catch\r\n\r\n--i\u015fleme tabi tutma\r\ndeclare @b bit, @ks smallint\r\nexec up_SatisTap 10248,1,2,1.2,0,@ks out,@b out\r\n\r\nif @b =1\r\nbegin\r\nselect '\u0130\u015flem Ba\u015far\u0131l\u0131.Kalan stok '+CAST(@ks as varchar(5))\r\nend\r\nelse\r\n\tselect '\u0130\u015flem Ba\u015far\u0131s\u0131z'<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Northwind &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-PRODESURLER&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; \/* Stored Procedure(Sakl\u0131 yordam) Metot insert,update vs. sql de saklan\u0131r g\u00fcvenlik performans network&#8217;teki veri \u00f6n belleklenmi\u015f execution plan<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[45,46,36],"class_list":["post-205","post","type-post","status-publish","format-standard","hentry","category-prosedur","tag-procedure","tag-prosedur-2","tag-sql-2","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Prosed\u00fcrler | F.Murat ALTINI\u015eIK<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Prosed\u00fcrler | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"Northwind -------------------PRODESURLER------------------------ \/* Stored Procedure(Sakl\u0131 yordam) Metot insert,update vs. sql de saklan\u0131r g\u00fcvenlik performans network&#039;teki veri \u00f6n belleklenmi\u015f execution plan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/\" \/>\n<meta property=\"og:site_name\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-14T21:40:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:22+00:00\" \/>\n<meta name=\"author\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:site\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"F.Murat ALTINI\u015eIK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Prosed\u00fcrler\",\"datePublished\":\"2010-08-14T21:40:42+00:00\",\"dateModified\":\"2017-04-16T12:40:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/\"},\"wordCount\":3,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"procedure\",\"prosedur\",\"sql\"],\"articleSection\":[\"Prosedurler\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/\",\"name\":\"Prosed\u00fcrler | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:40:42+00:00\",\"dateModified\":\"2017-04-16T12:40:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/prosedurler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Prosed\u00fcrler\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/\",\"name\":\"F.Murat ALTINI\u015eIK\",\"description\":\"HTML | PHP | C# | SQL | ASP.net | Bitcoin\",\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\",\"name\":\"F.Murat ALTINI\u015eIK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"caption\":\"F.Murat ALTINI\u015eIK\"},\"logo\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server\",\"sameAs\":[\"http:\/\/www.fethimurat.com\",\"https:\/\/www.facebook.com\/muratfethi\",\"https:\/\/www.instagram.com\/muratfethi\/\",\"https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/\",\"https:\/\/x.com\/muratfethi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Prosed\u00fcrler | F.Murat ALTINI\u015eIK","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/","og_locale":"tr_TR","og_type":"article","og_title":"Prosed\u00fcrler | F.Murat ALTINI\u015eIK","og_description":"Northwind -------------------PRODESURLER------------------------ \/* Stored Procedure(Sakl\u0131 yordam) Metot insert,update vs. sql de saklan\u0131r g\u00fcvenlik performans network'teki veri \u00f6n belleklenmi\u015f execution plan","og_url":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/","og_site_name":"F.Murat ALTINI\u015eIK","article_publisher":"https:\/\/www.facebook.com\/muratfethi","article_author":"https:\/\/www.facebook.com\/muratfethi","article_published_time":"2010-08-14T21:40:42+00:00","article_modified_time":"2017-04-16T12:40:22+00:00","author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Prosed\u00fcrler","datePublished":"2010-08-14T21:40:42+00:00","dateModified":"2017-04-16T12:40:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/"},"wordCount":3,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["procedure","prosedur","sql"],"articleSection":["Prosedurler"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/prosedurler\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/","url":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/","name":"Prosed\u00fcrler | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:40:42+00:00","dateModified":"2017-04-16T12:40:22+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/prosedurler\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/prosedurler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Prosed\u00fcrler"}]},{"@type":"WebSite","@id":"https:\/\/www.fethimurat.com\/blog\/#website","url":"https:\/\/www.fethimurat.com\/blog\/","name":"F.Murat ALTINI\u015eIK","description":"HTML | PHP | C# | SQL | ASP.net | Bitcoin","publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2","name":"F.Murat ALTINI\u015eIK","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","caption":"F.Murat ALTINI\u015eIK"},"logo":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/"},"description":"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server","sameAs":["http:\/\/www.fethimurat.com","https:\/\/www.facebook.com\/muratfethi","https:\/\/www.instagram.com\/muratfethi\/","https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/","https:\/\/x.com\/muratfethi"]}]}},"_links":{"self":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/comments?post=205"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/205\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}