{"id":110,"date":"2025-05-26T10:19:02","date_gmt":"2025-05-26T10:19:02","guid":{"rendered":"https:\/\/darjamalkova23.thkit.ee\/wpp\/?page_id=110"},"modified":"2025-05-26T10:19:02","modified_gmt":"2025-05-26T10:19:02","slug":"sql-protseduur","status":"publish","type":"page","link":"https:\/\/darjamalkova23.thkit.ee\/wpp\/sql-protseduur\/","title":{"rendered":"SQL protseduur"},"content":{"rendered":"\n<p>nagu funktsioonid programmeerimise keeles<\/p>\n\n\n\n<p>salvestatud protseduurid ( Store Procedure )<\/p>\n\n\n\n<p>tegevused, mis saab automaatselt teha ( INSERT INTO, ALTER TABLE, SELECT, DELETE, UPDATE )<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE linnad(\nlinnID int PRIMARY KEY identity(1,1),\nlinnNimi varchar(30) unique,\nelanikeArv int not null,\nmaakond varchar(25)\n);\n--Protseduur, mis lisab (INSERT) tabelisse andmed ja kohe n\u00e4itab (SELECT) tabeli\nCREATE PROCEDURE lisaLinn\n@linnNimi varchar(30),\n@elanikeArv int,\n@maakond varchar(25)\nAS\nBEGIN\nINSERT INTO linnad(linnNimi, elanikeArv, maakond)\nVALUES (@linnNimi, @elanikeArv, @maakond);\nSELECT * FROM linnad;\nEND;\n\n--kutse\nExec lisaLinn &#039;P\u00e4rnu&#039;, 30000, &#039;P\u00e4rnu&#039;;\n\n--protseduur, mis kustutab tabelist linnID j\u00e4rgi\nCREATE PROCEDURE kustutaLinn\n@id int\nAS\nBEGIN\nSELECT * FROM linnad;\nDELETE FROM linnad WHERE linnID=@id;\nSELECT * FROM linnad;\nEND\n\nEXEC kustutaLinn 4;\n\n--protseduur mis uuendab tabeli ja suurendab elanike arv 10%\nCREATE Procedure uuendaLinn\n@arv\nAS\nBEGIN\nSELECT * FROM linnad;\nUPDATE linnad SET elanikeArv=elanikeArv*1.1;\nSELECT * FROM linnad;\nEND\n\nEXEC uuendaLinn 0.05;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"674\" height=\"684\" src=\"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-content\/uploads\/2025\/05\/image.png\" alt=\"\" class=\"wp-image-112\" srcset=\"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-content\/uploads\/2025\/05\/image.png 674w, https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-content\/uploads\/2025\/05\/image-296x300.png 296w, https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-content\/uploads\/2025\/05\/image-600x609.png 600w, https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-content\/uploads\/2025\/05\/image-100x100.png 100w\" sizes=\"auto, (max-width: 674px) 100vw, 674px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>nagu funktsioonid programmeerimise keeles salvestatud protseduurid ( Store Procedure ) tegevused, mis saab automaatselt teha ( INSERT INTO, ALTER TABLE, SELECT, DELETE, UPDATE )<\/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-110","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages\/110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/comments?post=110"}],"version-history":[{"count":1,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages\/110\/revisions"}],"predecessor-version":[{"id":113,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages\/110\/revisions\/113"}],"wp:attachment":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/media?parent=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}