{"id":1047,"date":"2023-06-08T12:40:36","date_gmt":"2023-06-08T12:40:36","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=1047"},"modified":"2023-06-08T12:41:29","modified_gmt":"2023-06-08T12:41:29","slug":"salvestatud-protseduur","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/salvestatud-protseduur\/","title":{"rendered":"Salvestatud protseduur"},"content":{"rendered":"\n<p>Levinud tegevuste tarbeks on v\u00f5imalik andmebaasis salvestada protseduur. Nii saab andmebaasis teha valmis keerukad toimingud, mida hiljem vajaduse korral vaid \u00fche k\u00e4suga v\u00f5ib baasi haldusliidese v\u00f5i omakoostatud programmi kaudu v\u00e4lja kutsuda.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><a><\/a><a><\/a> Loomine<\/h5>\n\n\n\n<p>K\u00f5igepealt loomise n\u00e4ide:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE PROCEDURE kysiLapsed(@algaasta decimal)\nAS\nSELECT eesnimi, synniaasta FROM lapsed \nWHERE synniaasta&gt;=@algaasta\n<\/pre><\/div>\n\n\n<p>Kui selline k\u00e4sujada tipitakse SQL-serveri haldusliidesesse v\u00f5i sisestatakse muul moel k\u00e4sujadana, siis salvestatakse andmebaasi protseduur nimega kysiLapsed.<\/p>\n\n\n\n<p>Tulemusena tekib baasi haldusliidesesse alajaotisesse Programmability -&gt; Stored Procedures vastav salvestatud protseduur, mille kohta saab soovi korral ka uurida, millist t\u00fc\u00fcpi andmeid ta ette tahab ning millisel kujul tulemuse v\u00e4ljastab.<\/p>\n\n\n\n<p>Protseduur eeldab, et baasis leidub tabel &#8220;lapsed&#8221;, millel tulpadeks on v\u00e4hemasti eesnimi ja synniaasta. Protseduur v\u00e4ljastab laste andmed, kes on s\u00fcndinud etteantud aastal v\u00f5i hiljem. Halduskeskkonnas sobib k\u00e4ivitamiseks k\u00e4sklus kujul<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nEXEC kysiLapsed 1997\n<\/pre><\/div>\n\n\n<p>V\u00e4ljundiks loetelu nagu soovitud:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"308\" height=\"447\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-39.png\" alt=\"\" class=\"wp-image-1054\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-39.png 308w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-39-207x300.png 207w\" sizes=\"auto, (max-width: 308px) 100vw, 308px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Levinud tegevuste tarbeks on v\u00f5imalik andmebaasis salvestada protseduur. Nii saab andmebaasis teha valmis keerukad toimingud, mida hiljem vajaduse korral vaid \u00fche k\u00e4suga v\u00f5ib baasi haldusliidese v\u00f5i omakoostatud programmi kaudu v\u00e4lja kutsuda. Loomine K\u00f5igepealt loomise n\u00e4ide: Kui selline k\u00e4sujada tipitakse SQL-serveri haldusliidesesse v\u00f5i sisestatakse muul moel k\u00e4sujadana, siis salvestatakse andmebaasi protseduur nimega kysiLapsed. Tulemusena tekib baasi &hellip; <a href=\"https:\/\/tarkvara.thkit.ee\/veeb\/salvestatud-protseduur\/\" class=\"more-link\">Loe edasi <span class=\"screen-reader-text\">Salvestatud protseduur<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1047","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/1047","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/comments?post=1047"}],"version-history":[{"count":6,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/1047\/revisions"}],"predecessor-version":[{"id":1055,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/1047\/revisions\/1055"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=1047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}