{"id":61,"date":"2025-06-02T10:31:43","date_gmt":"2025-06-02T08:31:43","guid":{"rendered":"https:\/\/denissvarkov23.thkit.ee\/wwp\/?page_id=61"},"modified":"2025-06-02T10:38:29","modified_gmt":"2025-06-02T08:38:29","slug":"andmebaasid","status":"publish","type":"page","link":"https:\/\/denissvarkov23.thkit.ee\/wwp\/andmebaasid\/","title":{"rendered":"SQL protseduurd"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"391\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-3.png\" alt=\"\" class=\"wp-image-68\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-3.png 602w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-3-300x195.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n\n\n\n<p>3. Lisa sama tabeli oma protseduuri tegevusega, mis on erinev varem loodud protseduuritest.<\/p>\n\n\n\n<p>4. tee iga protseduuri kohta 2 screeni<\/p>\n\n\n\n<p>sp_helptext proc_nimi<\/p>\n\n\n\n<p>sp_help proc_nimi<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"234\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image.png\" alt=\"\" class=\"wp-image-62\" style=\"width:303px;height:auto\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image.png 448w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-300x157.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"116\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-1.png\" alt=\"\" class=\"wp-image-65\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-1.png 609w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-1-300x57.png 300w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"330\" height=\"131\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-2.png\" alt=\"\" class=\"wp-image-67\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-2.png 330w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-2-300x119.png 300w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/figure>\n\n\n\n<p style=\"font-size:52px\"><strong>1.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"509\" height=\"252\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-4.png\" alt=\"\" class=\"wp-image-72\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-4.png 509w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-4-300x149.png 300w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/figure>\n\n\n\n<p style=\"font-size:52px\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"333\" height=\"153\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-5.png\" alt=\"\" class=\"wp-image-73\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-5.png 333w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-5-300x138.png 300w\" sizes=\"auto, (max-width: 333px) 100vw, 333px\" \/><\/figure>\n\n\n\n<p style=\"font-size:52px\">2.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"302\" height=\"197\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-6.png\" alt=\"\" class=\"wp-image-75\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-6.png 302w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-6-300x196.png 300w\" sizes=\"auto, (max-width: 302px) 100vw, 302px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"331\" height=\"122\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-7.png\" alt=\"\" class=\"wp-image-76\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-7.png 331w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-7-300x111.png 300w\" sizes=\"auto, (max-width: 331px) 100vw, 331px\" \/><\/figure>\n\n\n\n<p style=\"font-size:52px\"><strong>3.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"358\" height=\"200\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-8.png\" alt=\"\" class=\"wp-image-77\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-8.png 358w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-8-300x168.png 300w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"284\" height=\"125\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-9.png\" alt=\"\" class=\"wp-image-78\"\/><\/figure>\n\n\n\n<p style=\"font-size:55px\"><strong>4.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"341\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-10.png\" alt=\"\" class=\"wp-image-79\" style=\"width:336px;height:auto\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-10.png 336w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-10-296x300.png 296w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"248\" height=\"142\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-11.png\" alt=\"\" class=\"wp-image-80\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"281\" height=\"119\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-12.png\" alt=\"\" class=\"wp-image-81\"\/><\/figure>\n\n\n\n<p style=\"font-size:60px\"><strong>5.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"903\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-13.png\" alt=\"\" class=\"wp-image-82\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-13.png 433w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-13-144x300.png 144w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"854\" height=\"691\" src=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-14.png\" alt=\"\" class=\"wp-image-83\" srcset=\"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-14.png 854w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-14-300x243.png 300w, https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-content\/uploads\/2025\/06\/image-14-768x621.png 768w\" sizes=\"auto, (max-width: 854px) 100vw, 854px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>3. Lisa sama tabeli oma protseduuri tegevusega, mis on erinev varem loodud protseduuritest. 4. tee iga protseduuri kohta 2 screeni sp_helptext proc_nimi sp_help proc_nimi 1. 2. 3. 4. 5.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"class_list":["post-61","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/pages\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":6,"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/pages\/61\/revisions"}],"predecessor-version":[{"id":89,"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/pages\/61\/revisions\/89"}],"wp:attachment":[{"href":"https:\/\/denissvarkov23.thkit.ee\/wwp\/wp-json\/wp\/v2\/media?parent=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}