{"id":199,"date":"2025-05-26T12:57:31","date_gmt":"2025-05-26T10:57:31","guid":{"rendered":"https:\/\/maratsaukans23.thkit.ee\/vp\/?page_id=199"},"modified":"2025-05-27T11:38:36","modified_gmt":"2025-05-27T09:38:36","slug":"procedure","status":"publish","type":"page","link":"https:\/\/maratsaukans23.thkit.ee\/vp\/procedure\/","title":{"rendered":"protseduurid"},"content":{"rendered":"\n

\u00fclesanne<\/p>\n\n\n\n

tabel: puu (id, puunimi, pikkus, asukoht) <\/p>\n\n\n\n

protsessorid:<\/strong><\/p>\n\n\n\n

1. Protseduur, mille abil saab lisada uued puud tabelisse<\/p>\n\n\n\n

<\/p>\n\n\n\n

2. Protseduur, mis leiab keskmine pikkus tabelis puu1)l\u00f5i tabeli<\/span><\/p>\n\n\n\n


3. Protseduur, mis uuendab puu pikkused 10% suurem<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

1) l\u00f5i tabeli<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

2)<\/strong> andmete lisamine tabelisse<\/strong><\/p>\n\n\n\n

create procedure Lisapuu<\/p>\n\n\n\n

@puuid int, <\/p>\n\n\n\n

@puunimi varchar(25), <\/p>\n\n\n\n

@pikkus int, <\/p>\n\n\n\n

@asukoht varchar(30)<\/p>\n\n\n\n

AS <\/p>\n\n\n\n

BEGIN<\/p>\n\n\n\n

insert into puu(puunimi, pikkus, asukoht)<\/p>\n\n\n\n

values (@puunimi, @pikkus, @asukoht); <\/p>\n\n\n\n

select * from puu;END;EXEC Lisapuu 2, ‘tamm’, 10, ‘Maardu’;<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

3)Keskmine puu pikkus<\/strong><\/p>\n\n\n\n

Create procedure keskminepuu <\/p>\n\n\n\n

AS<\/p>\n\n\n\n

BEGIN<\/p>\n\n\n\n

select * from puu;<\/p>\n\n\n\n

select AVG(pikkus) as keskmine_pikkus from puu; <\/p>\n\n\n\n

end;<\/p>\n\n\n\n

exec keskminepuu;<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

4) Protseduur, mis uuendab puu pikkused 10 % suurem<\/strong>
<\/p>\n\n\n\n

Create procedure suurPuu<\/p>\n\n\n\n

@arv decimal (5,2)<\/p>\n\n\n\n

AS<\/p>\n\n\n\n

BEGIN<\/p>\n\n\n\n

select * from puu;<\/p>\n\n\n\n

Update puu set pikkus=pikkus*@arv;<\/p>\n\n\n\n

select * from puu;<\/p>\n\n\n\n

END;<\/p>\n\n\n\n

EXEC suurPuu 10;<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

5) Protseduur, mis kustutab tabelist id j\u00e4rgi<\/strong><\/p>\n\n\n\n

create procedure kustutapuu<\/p>\n\n\n\n

@id int<\/p>\n\n\n\n

AS<\/p>\n\n\n\n

BEGIN<\/p>\n\n\n\n

select * from puu;<\/p>\n\n\n\n

Delete from puu WHERE puuid=@id; <\/p>\n\n\n\n

select * from puu;<\/p>\n\n\n\n

end;<\/p>\n\n\n\n

exec kustutapuu @id=1;<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u00fclesanne tabel: puu (id, puunimi, pikkus, asukoht) protsessorid: 1. Protseduur, mille abil saab lisada uued puud tabelisse 2. Protseduur, mis leiab keskmine pikkus tabelis puu1)l\u00f5i tabeli 3. Protseduur, mis uuendab puu pikkused 10% suurem 1) l\u00f5i tabeli 2) andmete lisamine tabelisse create procedure Lisapuu @puuid int, @puunimi varchar(25), @pikkus int, @asukoht varchar(30) AS BEGIN insert […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-199","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":3,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages\/199\/revisions"}],"predecessor-version":[{"id":220,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages\/199\/revisions\/220"}],"wp:attachment":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/media?parent=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}