{"id":87,"date":"2026-02-11T09:04:18","date_gmt":"2026-02-11T07:04:18","guid":{"rendered":"https:\/\/timofeistoljarov.wordpress.com\/?page_id=87"},"modified":"2026-02-11T09:04:18","modified_gmt":"2026-02-11T07:04:18","slug":"sql-protseduurid","status":"publish","type":"page","link":"https:\/\/timofeistoljarov.eu\/wp\/andmebaasid\/sql-protseduurid\/","title":{"rendered":"SQL protseduurid"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong><br>Protseduurid (salvestatud protseduurid)<\/strong>\u00a0on eelnevalt salvestatud SQL-k\u00e4skude kogumid keeles SQL, mida kasutatakse korduvate toimingute automatiseerimiseks andmebaasis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">see on sama mis on programmeerimisel funktsioonid<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--procedure mis lisab INSERT andmeid tabelisse brands\ncreate procedure lisaBrand\n@brand_nimi varchar(30)\nas\nbegin\ninsert into brands(brand_name) values (@brand_nimi);\nselect * from brands;\nend;\n--procedure check\nexec lisaBrand &#039;Audi&#039;;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/timofeistoljarov.eu\/wp\/wp-content\/uploads\/2026\/02\/786872a7-89ce-4f1a-aef1-0448c427c2bf-1.png?w=287\" alt=\"\" class=\"wp-image-92\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Protseduurid (salvestatud protseduurid)\u00a0on eelnevalt salvestatud SQL-k\u00e4skude kogumid keeles SQL, mida kasutatakse korduvate toimingute automatiseerimiseks andmebaasis. see on sama mis on programmeerimisel funktsioonid<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":7,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-87","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages\/87","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/comments?post=87"}],"version-history":[{"count":0,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages\/87\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages\/7"}],"wp:attachment":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/media?parent=87"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}