{"id":69,"date":"2009-03-25T11:57:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=69"},"modified":"2009-03-25T11:57:00","modified_gmt":"1970-01-01T00:00:00","slug":"stored-procedure-kullanmanin-avantajlari-ve-stored-procedureler-hakkinda-bilgi","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2009\/03\/25\/stored-procedure-kullanmanin-avantajlari-ve-stored-procedureler-hakkinda-bilgi\/","title":{"rendered":"Stored Procedure Kullanmanin Avantajlari ve Stored Procedureler Hakkinda Bilgi"},"content":{"rendered":"

Store procedure<\/span><\/strong><\/p>\n

Türkçe anlami olarak sakli yordamlar seklinde çevirebilir.Store procedürler,sorgularimizin daha hizli ve esnek çalismasina olanak saglar.Bir kere derlendikleri için bu hiza olumlu etki yapar,ayrica client tarafinda degil server tarafinda çalisirlar,iyi bir sunucu üzerinde çok optimal sonuçlar verebilirler.<\/span><\/p>\n

Sql server üzerinde 3 tip stored procedür vardir.<\/span><\/p>\n

1.    <\/span><\/span><\/span>System Store Prosedürleri :<\/span><\/strong> SQL Server tarafindan isletilen prosedürler, .sp_ önekine sahiptirler.<\/span><\/p>\n

2.    <\/span><\/span><\/span>Extend Store Prosedüleri :<\/span><\/strong> Server disinda çalisan dinamik kütüphanelerdir, .xp_önekine sahiptir.<\/span><\/p>\n

3.    <\/span><\/span><\/span>Local Store Prosedürler : <\/span><\/strong>Kendimizin olusturdugu Sql Server üzerinde çalisan prosedürler.<\/span><\/p>\n

SQL Server management kullanarak yeni bir local store procedür olusturma islemi ise söyledir.<\/span><\/p>\n

 <\/p>\n

\"\" <\/span>.<\/a><\/p>\n

T-Sql komutu kullanarak yeni bir stored procedür yazma kodlari ise söyledir.<\/span><\/p>\n\n \n \n
\n

set<\/span> ANSI_NULLS<\/span> ON<\/span><\/span><\/p>\n

set<\/span> QUOTED_IDENTIFIER<\/span> ON<\/span><\/span><\/p>\n

go<\/span><\/p>\n

 <\/span><\/p>\n

— =============================================<\/span><\/p>\n

— Author:               <\/span><muratyýlmaz><\/span><\/p>\n

— Create date: <Create Date,,><\/span><\/p>\n

— Description:         <\/span><Description,,><\/span><\/p>\n

— =============================================<\/span><\/p>\n

ALTER<\/span> PROCEDURE<\/span> [dbo].<\/span>[murat](<\/span>                    <\/span><\/span><\/p>\n

@ADI NVARCHAR<\/span>(<\/span>50),<\/span>                                                 <\/span><\/span><\/p>\n

@SOYADI NVARCHAR<\/span>(<\/span>50),<\/span><\/span><\/p>\n

@SEHIR NVARCHAR<\/span>(<\/span>50)<\/span><\/span><\/p>\n

)<\/span>                                  <\/span><\/span><\/p>\n

             <\/span>                                                             <\/span><\/span><\/p>\n

AS<\/span>                                                                       <\/span><\/span><\/p>\n

set<\/span> @ADI =<\/span> ‘"’<\/span> +<\/span> @ADI +<\/span> ‘*"’<\/span><\/span><\/p>\n

set<\/span> @SOYADI =<\/span> ‘"’<\/span> +<\/span> @SOYADI +<\/span> ‘*"’<\/span><\/span><\/p>\n

set<\/span> @SEHIR =<\/span> ‘"’<\/span> +<\/span> @SEHIR +<\/span> ‘*"’<\/span><\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

                                                                          <\/span><\/span><\/p>\n

SELECT<\/span>  <\/span>*<\/span>                                                            <\/span><\/span><\/p>\n

FROM<\/span> murat_tablo                                                    <\/span><\/span><\/p>\n

WHERE<\/span> contains<\/span> (<\/span>[Column 6],<\/span>@ADI)<\/span> and<\/span> contains<\/span> (<\/span>[Column 7],<\/span>@SOYADI)<\/span> and<\/span> contains<\/span> (<\/span>[Column 11],<\/span>@SEHIR)<\/span><\/span><\/p>\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n

 <\/span><\/p>\n

Burada murat adinda bir stored procedür tanimladik ve bu prosedürümüze de 3 adet parametre gönderdirk. Bunlar Ad,soyadi,sehir<\/span><\/p>\n

Bu gönderdigimiz parametlerle bildigimiz select sorgusunu yazdik.<\/span><\/p>\n

Iyi çalismalar…<\/span><\/p>","protected":false},"excerpt":{"rendered":"

Türkçe anlami olarak sakli yordamlar seklinde çevirebilir.Store procedürler,sorgularimizin daha hizli ve esnek çalismasina olanak saglar.Bir kere derlendikleri için bu hiza olumlu etki yapar,ayrica client tarafinda degil server tarafinda çalisirlar,iyi bir sunucu üzerinde çok optimal sonuçlar verebi<\/p>\n","protected":false},"author":522,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[422],"tags":[3877,4136,5022,6012,5628,5239,5792],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/69"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/522"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/69\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}