{"id":81,"date":"2017-11-30T00:00:00","date_gmt":"2017-11-30T00:00:00","guid":{"rendered":"http:\/\/www.eyurtsever.com\/?p=81"},"modified":"6041-03-16T10:34:54","modified_gmt":"6041-03-16T07:34:54","slug":"asp-stored-procedure-kullanimi-mssql","status":"publish","type":"post","link":"https:\/\/www.eyurtsever.com\/index.php\/asp-stored-procedure-kullanimi-mssql","title":{"rendered":"ASP Stored Procedure Kullan\u0131m\u0131 ( MsSql )"},"content":{"rendered":"<p><a title=\"asp ile stored procedure kullan\u0131m\u0131\" href=\"http:\/\/www.eyurtsever.com\/index.php\/asp-stored-procedure-kullanimi-mssql\/\">Asp ile stored procedure kullan\u0131m\u0131<\/a> \u00e7ok basittir. Ve \u00e7ok \u00f6nemli avantajlar\u0131 vard\u0131r. En \u00f6nemli avantaj\u0131 sitenin h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131d\u0131r. Stored Procedure ile yap\u0131lan sorgular g\u00f6zle g\u00f6r\u00fcl\u00fcr bir h\u0131z art\u0131\u015f\u0131 sa\u011flar.<br \/>\n&nbsp;<br \/>\n<a title=\"stored procedure nas\u0131l kullan\u0131l\u0131r?\" href=\"http:\/\/www.eyurtsever.com\/index.php\/asp-stored-procedure-kullanimi-mssql\/\">Asp ile stored procedure nas\u0131l kullan\u0131l\u0131r?<\/a><br \/>\n\u00d6ncelikle mssql veritaban\u0131m\u0131z\u0131 olu\u015fturduk ve tablolar\u0131m\u0131z\u0131da olu\u015fturduk.<br \/>\nBeraber \u00f6rnek yapal\u0131m:<br \/>\ntablo ad\u0131m\u0131z : TblHaber olsun<br \/>\nalanlar : id , baslik,detay<br \/>\n<!--more--><br \/>\n\u015eimdi Procedure olu\u015ftural\u0131m.<br \/>\nSql server\u0131m\u0131z\u0131 a\u00e7t\u0131k<br \/>\nveritaban\u0131 ad\u0131 &gt; Programmability &gt; Stored Procedures\u00a0 sa\u011f t\u0131klay\u0131p New Stored Procedure diyoruz.<br \/>\nQuery sayfas\u0131 a\u00e7\u0131ld\u0131. \u0130\u00e7indekileri silelim.<br \/>\nve a\u015fa\u011f\u0131daki gibi procedure olu\u015ftural\u0131m<\/p>\n<pre class=\"brush:vb\">CREATE PROCEDURE HaberSirala\nAS\nBEGIN\nSELECT * FROM TblHaber ORDER BY id DESC\nEND\nGO\n<\/pre>\n<p>Procedure kodlarm\u0131z\u0131 yazd\u0131k ve Execute dedik. Procedure olu\u015fturmu\u015f olduk.<br \/>\n&nbsp;<br \/>\n\u015eimdi sayfam\u0131zdan \u00e7a\u011f\u0131ral\u0131m.<br \/>\nBa\u011flant\u0131 kodlar\u0131m\u0131z\u0131 yazd\u0131\u011f\u0131m\u0131z\u0131 farz ediyorum. bkz : <a title=\"asp ile veritaban\u0131 ba\u011flant\u0131s\u0131\" href=\"http:\/\/www.eyurtsever.com\/index.php\/asp-ve-asp-net-veritabani-baglantilari\/\">Asp ile veritaban\u0131 ba\u011flant\u0131s\u0131 yapmak<\/a><br \/>\n&nbsp;<\/p>\n<pre class=\"brush:vb\">&lt;% set\u00a0 rs = baglanti.execute(\"Exec HaberSirala\")\u00a0 ' procedure ad\u0131m\u0131z\u0131 yazd\u0131k\ndo while not rs.eof\n%&gt;\n&lt;%=rs(\"baslik\")%&gt; &lt;br \/&gt;\n&lt;%=rs(\"detay\")%&gt;\n&lt;% rs.movenext:loop\nrs.close\nset rs = nothing %&gt;\n<\/pre>\n<p>&nbsp;<br \/>\n\u0130\u015fte hepsi bu kadar, procedure olu\u015ftururken sorgunuzu kendinize g\u00f6re de\u011fi\u015ftirip bu \u015fekilde \u00e7a\u011f\u0131rabilirsiniz.<br \/>\n&nbsp;<br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Asp ile stored procedure kullan\u0131m\u0131 \u00e7ok basittir. Ve \u00e7ok \u00f6nemli avantajlar\u0131 vard\u0131r. En \u00f6nemli avantaj\u0131 sitenin h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131d\u0131r. Stored Procedure ile yap\u0131lan sorgular g\u00f6zle g\u00f6r\u00fcl\u00fcr bir h\u0131z art\u0131\u015f\u0131 sa\u011flar. &nbsp; Asp ile stored procedure nas\u0131l kullan\u0131l\u0131r? \u00d6ncelikle mssql veritaban\u0131m\u0131z\u0131 olu\u015fturduk ve tablolar\u0131m\u0131z\u0131da olu\u015fturduk. Beraber \u00f6rnek yapal\u0131m: tablo ad\u0131m\u0131z : TblHaber olsun alanlar : id , [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,13],"tags":[35,47,101,295,304],"_links":{"self":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/81"}],"collection":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/comments?post=81"}],"version-history":[{"count":0,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/81\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/media?parent=81"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/categories?post=81"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/tags?post=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}