{"id":2391,"date":"2012-03-23T22:43:01","date_gmt":"2012-03-23T22:43:01","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=2391"},"modified":"2019-02-28T11:20:55","modified_gmt":"2019-02-28T11:20:55","slug":"sql-server-ile-stored-procedure-a-giris","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-ile-stored-procedure-a-giris\/","title":{"rendered":"SQL Server \u0130le Stored Procedure a Giri\u015f"},"content":{"rendered":"

Merhaba De\u011ferli Arkada\u015flar….<\/p>\n

Bu yaz\u0131mda sizlere SQL Server ile Stored Procedure a basit bir giri\u015f yapaca\u011f\u0131m. Daha \u00f6nceki\u00a0Yaz\u0131mda<\/a>\u00a0sizlere Stored procedure un ne oldu\u011funu anlatm\u0131\u015ft\u0131m.O y\u00fczden bu yaz\u0131y\u0131 okumadan \u00f6nce Stored procedure bilmeyen arkada\u015flar\u0131n \u00a0bahsetti\u011fim yaz\u0131y\u0131<\/a>\u00a0okumalar\u0131 gerekmektedir. SQL Server da yazd\u0131\u011f\u0131m\u0131z Stored procedure ler database serverda sakland\u0131\u011f\u0131 i\u00e7in g\u00fcvenli\u011fi uygulama katman\u0131nda yazm\u0131\u015f oldu\u011fumuz SQL kodlar\u0131ndan daha g\u00fcvenli ve daha h\u0131zl\u0131 oldu\u011fundan dolay\u0131 s\u00fcrekli olarak SQL Server da yada Oracle veritabanlar\u0131nda Stored procedure lar haz\u0131rlayacaks\u0131n\u0131zd\u0131r.<\/p>\n

\u015eimdi Giri\u015f a\u015famas\u0131nda bilmeyenler i\u00e7in SQL Server 2005 de Stored Procedure \u00fcn nerden a\u00e7\u0131ld\u0131\u011f\u0131n\u0131 a\u015fa\u011f\u0131daki resimden g\u00f6sterdim.<\/p>\n

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

<\/p>\n

 <\/p>\n\n

Yukar\u0131daki resimde ki gibi New Stored Procedure a t\u0131klad\u0131\u011f\u0131m\u0131z zaman kar\u015f\u0131m\u0131za Sistemin Default olarak getirdi\u011fi baz\u0131 kodlar var.Asl\u0131nda bu kodlar\u0131 ayr\u0131nt\u0131l\u0131 incelerseniz ba\u015flang\u0131\u00e7 a\u015famas\u0131nda Stored procedure yazabilirsiniz.A\u015fa\u011f\u0131daki resimde New Stored Procedure e t\u0131klad\u0131\u011f\u0131m\u0131zda kar\u015f\u0131m\u0131za \u00e7\u0131kmas\u0131 gereken ekran g\u00f6r\u00fcnmektedir.<\/p>\n

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

\u015eimdi basit anlamda bir Stored procedure \u00fc yaz\u0131p Derleyip sistem \u00fczerinde ko\u015ftu\u011fumuz zaman verece\u011fi \u00e7\u0131kt\u0131y\u0131 size g\u00f6sterece\u011fim. Veritaban\u0131m da var olan \u00a0PersonalInformation tablosunun verilerini Stored Procedure yazarak listeleyecem. Yukar\u0131daki \u00d6rne\u011fin ayn\u0131s\u0131 bir Stored procedure yazd\u0131m ve Stored Procedure mun ismini\u00a0sp_KisiListele olarak belirledim. Stored Procedure mun son hali a\u015fa\u011f\u0131daki gibidir.<\/p>\n

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

Yukar\u0131daki \u00f6rnekte bir Procedure \u00fc Create DDL (Data Definition Language) kodu ile olu\u015fturduk. Create,Alter,Drop vb. DDL komutlar\u0131 n\u0131 Stored procedure yazarken \u00e7ok kullanacaks\u0131n\u0131z. Create ile bir procedure olu\u015fturuldu\u011fu gibi Alter komutuyla da bir stored procedure de yapm\u0131\u015f oldu\u011fumuz de\u011fi\u015fiklikleri derleyip de\u011fi\u015ftirebiliriz. Drop komutuyla da sistemde var olan bir Stored Procedure \u00fc kald\u0131rabilirsiniz.<\/p>\n

\u015eimdi Projeyi f5 tu\u015fuyla derledi\u011finiz zaman e\u011fer hata yapmam\u0131\u015fsan\u0131z a\u015fa\u011f\u0131daki gibi Yazm\u0131\u015f oldu\u011funuz Stored Procedure n\u00fcz\u00fcn ba\u015far\u0131l\u0131 bir \u015fekilde derlendi\u011fine dair bir mesaj almal\u0131s\u0131n\u0131z.<\/p>\n

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

\u015eimdi yapm\u0131\u015f oldu\u011fum Stored procedure \u00fc \u00e7al\u0131\u015ft\u0131r\u0131p sonucu g\u00f6recem.Bunun i\u00e7in yeni bir Query ekran\u0131na a\u015fa\u011f\u0131daki kodu yazal\u0131m.<\/p>\n

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

Exec komutu + Stored procedure \u00fcn ad\u0131n\u0131 yaz\u0131p f5 e t\u0131klad\u0131\u011f\u0131n\u0131z zaman a\u015fa\u011f\u0131daki gibi PersonalInformation tablosunda var olan verileri listelenecektir.<\/p>\n

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

Create komutuyla yeni bir Stored procedure olu\u015fturdu\u011fumuz gibi Alter komutuyla ayn\u0131 Stored Procedure \u00fcm\u00fcz\u00fcn i\u015flevini de\u011fi\u015ftirip 180251 nolu Salih Deveci kayd\u0131n\u0131 Silecez. Yazm\u0131\u015f oldu\u011fumuz Stored Procedure \u00fcm\u00fcz\u00fc a\u015fa\u011f\u0131daki gibi de\u011fi\u015ftirecez.<\/p>\n

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

Yazm\u0131\u015f oldu\u011fumuz Stored Procedure \u00fc Exec SP Ad\u0131 ve Varsa Parametre komutuyla A\u015fa\u011f\u0131daki gibi \u00e7al\u0131\u015ft\u0131racaz.<\/p>\n

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

Uygulamay\u0131 f5 ilr Execute etti\u011fimiz Zaman PersonalInformation tablosundaki 180251 numaral\u0131 Salih Deveci kayd\u0131n silindi\u011fini g\u00f6recez.<\/p>\n

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

Son olarak yazm\u0131\u015f oldu\u011fumuz basit SP yi sistemden Drop komutuyla silelim. \u00d6ncelikle Yazm\u0131\u015f oldu\u011fumuz sp_KisiListele adl\u0131 Stored procedure \u00fc database deki yerini g\u00f6relim.<\/p>\n

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

Yukar\u0131da da belirtti\u011fim gibi Database Server \u00fczerinde var olan bir Stored Procedure \u00fc silmek i\u00e7in Drop PROC <SP Ad\u0131> komutunu kullanaca\u011f\u0131z.<\/p>\n

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

Bu komutu Execute ettikten sonra Database Server a gidip bak\u0131yoruz ve a\u015fa\u011f\u0131da g\u00f6r\u00fcnd\u00fc\u011f\u00fc gibi sp_KisiListele adl\u0131 Stored Procedure m\u00fcz sistemden silinmi\u015ftir.<\/p>\n

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

Uygulaman\u0131n \u00e7\u0131kt\u0131s\u0131n\u0131da verdikten sonra bu yaz\u0131m\u0131n sonuna geldi\u011fimi belirtmek isterim. Bu yaz\u0131da k\u0131saca SQL Server 2005 de Bir Stored procedure \u00fcn nas\u0131l haz\u0131rland\u0131\u011f\u0131n\u0131 g\u00f6sterdim. Stored Procedure ile alakal\u0131 temel bilgileri bildi\u011finizi varsayarak anlatt\u0131m. Bir sonraki yaz\u0131mda g\u00f6r\u00fc\u015fmek dile\u011fiyle Esen Kal\u0131n…!!<\/p>\n

 <\/p>\n\n

 <\/p>\n

Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7×24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span>\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n

– Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Exadata Bak\u0131m ve Destek<\/span>
\n– SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Goldengate Bak\u0131m ve Destek<\/span>
\n– Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Linux Bak\u0131m ve Destek<\/span>
\n– Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EBS Bak\u0131m ve Destek<\/span>
\n– Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Weblogic Bak\u0131m ve Destek<\/span>
\n– Oracle Veritaban\u0131 E\u011fitimleri<\/span>
\n– Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle VM Server Bak\u0131m ve Destek<\/span>
\n– Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EPPM Bak\u0131m ve Destek<\/span>
\n– Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Primavera Bak\u0131m ve Destek<\/span>
\n– Oracle E\u011fitimleri<\/span>
\n– SQL Server E\u011fitimleri<\/span>
\n– Goldengate E\u011fitimleri<\/span>
\n– Exadata E\u011fitimleri<\/span>
\n– Linux E\u011fitimleri<\/span>
\n– Oracle EBS E\u011fitimleri<\/span>
\n– Oracle VM Server E\u011fitimleri<\/span>
\n– Weblogic E\u011fitimleri<\/span>
\n– Oracle EPPM E\u011fitimleri<\/span>
\n– Oracle Primavera E\u011fitimleri<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Merhaba De\u011ferli Arkada\u015flar…. Bu yaz\u0131mda sizlere SQL Server ile Stored Procedure a basit bir giri\u015f yapaca\u011f\u0131m. Daha \u00f6nceki\u00a0Yaz\u0131mda\u00a0sizlere Stored procedure un ne oldu\u011funu anlatm\u0131\u015ft\u0131m.O y\u00fczden bu yaz\u0131y\u0131 okumadan \u00f6nce Stored procedure bilmeyen arkada\u015flar\u0131n \u00a0bahsetti\u011fim yaz\u0131y\u0131\u00a0okumalar\u0131 gerekmektedir. SQL Server da yazd\u0131\u011f\u0131m\u0131z Stored procedure ler database serverda sakland\u0131\u011f\u0131 i\u00e7in g\u00fcvenli\u011fi uygulama katman\u0131nda yazm\u0131\u015f oldu\u011fumuz SQL kodlar\u0131ndan daha …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19],"tags":[1028,1031,1513,1514,1515,1578,1579,1580,1581,1582,1685,1688,1687,1689,1691,1690,1692,1693,1694],"class_list":["post-2391","post","type-post","status-publish","format-standard","","category-sql-server","tag-mehmet-deveci","tag-mehmet-salih-deveci","tag-sakli-yordam","tag-sakli-yordamlar","tag-salih-deveci","tag-sql-server-2005","tag-sql-server-2005-ile-stored-procedure-hazirlama","tag-sql-server-2005-ile-stored-procedure-olusturma","tag-sql-server-2005-stored-procedure","tag-sql-server-2005-stored-procedure-ornegi","tag-stored-procedure","tag-stored-procedure-kullanimi","tag-stored-procedure-kullanmanin-avantajlari","tag-stored-procedure-nasil-kullanilir","tag-stored-procedure-neden-gereklidir","tag-stored-procedure-neden-onemlidir","tag-stored-procedure-nedir","tag-stored-procedure-nerelerde-kullanilir","tag-stored-procedures"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=2391"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2391\/revisions"}],"predecessor-version":[{"id":5944,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2391\/revisions\/5944"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=2391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=2391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=2391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}