{"id":260,"date":"2025-05-27T09:35:45","date_gmt":"2025-05-27T07:35:45","guid":{"rendered":"https:\/\/markmaslov23.thkit.ee\/wp\/?page_id=260"},"modified":"2025-05-27T09:41:39","modified_gmt":"2025-05-27T07:41:39","slug":"sql-protseduurid","status":"publish","type":"page","link":"https:\/\/markmaslov23.thkit.ee\/wp\/sql-protseduurid\/","title":{"rendered":"SQL Protseduurid"},"content":{"rendered":"\n<p>Nagu funktsioonid programmeerimise keeles<br>salvestatud protseduurid (Store procedure)<\/p>\n\n\n\n<p><br>Tegevused,mis saab automaatselt teha (INSERT,ALTER TABLE,SELECT,DELETE,UPDATE)<br><br><\/p>\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\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\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<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate procedure uuendaLinn\n@arv decimal(5,2) \nas\nbegin\nselect * from linnad\nupdate linnad set elanikeArv=elanikeArv*@arv;\nselect * from linnad;\nend\n\n--kutse\nexec uuendaLinn 0.05;\n<\/pre><\/div>\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/maricopaop12345.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-2.png?w=317\" alt=\"\" class=\"wp-image-26\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/maricopaop12345.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-3.png?w=992\" alt=\"\" class=\"wp-image-28\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/maricopaop12345.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-5.png?w=994\" alt=\"\" class=\"wp-image-31\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/maricopaop12345.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-6.png?w=949\" alt=\"\" class=\"wp-image-33\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/maricopaop12345.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-7.png?w=910\" alt=\"\" class=\"wp-image-34\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/maricopaop12345.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-8.png?w=1024\" alt=\"\" class=\"wp-image-36\"\/><\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Nagu funktsioonid programmeerimise keelessalvestatud protseduurid (Store procedure) Tegevused,mis saab automaatselt teha (INSERT,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-260","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":3,"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/260\/revisions"}],"predecessor-version":[{"id":269,"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/260\/revisions\/269"}],"wp:attachment":[{"href":"https:\/\/markmaslov23.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}