{"id":369,"date":"2026-03-16T09:50:22","date_gmt":"2026-03-16T07:50:22","guid":{"rendered":"https:\/\/olegberezevski.wordpress.com\/?page_id=369"},"modified":"2026-03-16T09:50:22","modified_gmt":"2026-03-16T07:50:22","slug":"protseduurid-2","status":"publish","type":"page","link":"https:\/\/olegberezevski.eu\/wp\/protseduurid-2\/","title":{"rendered":"Protseduurid"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">1. Video protseduurid<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-10.png?w=525\" alt=\"\" class=\"wp-image-379\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-9.png?w=945\" alt=\"\" class=\"wp-image-377\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-8.png?w=945\" alt=\"\" class=\"wp-image-376\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-7.png?w=945\" alt=\"\" class=\"wp-image-375\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-6.png?w=945\" alt=\"\" class=\"wp-image-374\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Oma 2 protseduurid 3 jaoks<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-5.png?w=945\" alt=\"\" class=\"wp-image-373\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-4.png?w=945\" alt=\"\" class=\"wp-image-372\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Oma 2 protseduurid 4 jaoks<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-3.png?w=775\" alt=\"\" class=\"wp-image-371\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-2.png?w=945\" alt=\"\" class=\"wp-image-370\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/5e2591f4-5779-495d-ae06-bb9b97d58b28.png?w=261\" alt=\"\" class=\"wp-image-382\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/7801aa5e-8697-4c34-9748-c7460aec1a05.png?w=1024\" alt=\"\" class=\"wp-image-383\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Protseduur mis kuvab Product manufacturer ja price<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--Protseduur mis kuvab Product manufacturer ja price\nCREATE PROCEDURE ProductSummary\nAS\nBEGIN\nSELECT ProductName AS Product, Manufacturer, Price\nFROM Products\nEND;\n--Kutse\nEXEC ProductSummary;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/9989b7b4-376b-4c92-a061-1dc255ccde19.png?w=312\" alt=\"\" class=\"wp-image-305\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Protseduur mis lisab uus produkt<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--Protseduur mis lisab uus produkt\nCREATE PROCEDURE AddProduct\n    @name NVARCHAR(20),\n    @manufacturer NVARCHAR(20),\n    @count INT,\n    @price MONEY\nAS\nINSERT INTO Products(ProductName, Manufacturer, ProductCount, Price) \nVALUES(@name, @manufacturer, @count, @price);\n--Kutse\nEXEC AddProduct &#039;Riided2&#039;, &#039;Nike&#039;, 21000, 61.93;\n\n--Kutse2\nDECLARE @prodName NVARCHAR(20), @company NVARCHAR(20);\nDECLARE @prodCount INT, @price MONEY\nSET @prodName = &#039;Galaxy C7&#039;\nSET @company = &#039;Samsung&#039;\nSET @price = 220\nSET @prodCount = 5\n \nEXEC AddProduct @prodName, @company, @prodCount, @price\n \nSELECT * FROM Products\n\n--Kutse 3\nDECLARE @prodName NVARCHAR(20), @company NVARCHAR(20);\nSET @prodName = &#039;Honor 9&#039;\nSET @company = &#039;Huawei&#039;\n \nEXEC AddProduct @name = @prodName, \n                @manufacturer=@company,\n                @count = 3, \n                @price = 18000\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/af107bde-34a1-4f89-9ca7-578c14086c52.png?w=443\" alt=\"\" class=\"wp-image-303\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Protsedure ilma kasutava parametriga<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--Protsedure ilma kasutava parametriga\nCREATE PROCEDURE AddProductWithOptionalCount\n    @name NVARCHAR(20),\n    @manufacturer NVARCHAR(20),\n    @price MONEY,\n    @count INT = 1\nAS\nINSERT INTO Products(ProductName, Manufacturer, ProductCount, Price) \nVALUES(@name, @manufacturer, @count, @price)\n\n--Kutse\nDECLARE @prodName NVARCHAR(20), @company NVARCHAR(20), @price MONEY\nSET @prodName = &#039;Redmi Note 5A&#039;\nSET @company = &#039;Xiaomi&#039;\nSET @price = 22000\n \nEXEC AddProductWithOptionalCount @prodName, @company, @price\n \nSELECT * FROM Products\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/f66b4650-024d-475a-8919-2a8fbf399f6f.png?w=406\" alt=\"\" class=\"wp-image-302\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Protseduur koos OUTPUT parametriga<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--Protseduur koos OUTPUT parametriga\nCREATE PROCEDURE GetPriceStats\n    @minPrice MONEY OUTPUT,\n    @maxPrice MONEY OUTPUT\nAS\nSELECT @minPrice = MIN(Price),  @maxPrice = MAX(Price)\nFROM Products\n\n--Kutse\nDECLARE @minPrice MONEY, @maxPrice MONEY\n \nEXEC GetPriceStats @minPrice OUTPUT, @maxPrice OUTPUT\n \nPRINT &#039;Minimaalne hind &#039; + CONVERT(VARCHAR, @minPrice)\nPRINT &#039;Maksimaalne hind &#039; + CONVERT(VARCHAR, @maxPrice)\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/b04c1397-4baa-4cf6-a254-a0dbd7714707.png?w=517\" alt=\"\" class=\"wp-image-300\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">S\u00fcsteemi protseduurid <\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-12.png?w=805\" alt=\"\" class=\"wp-image-407\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-13.png?w=709\" alt=\"\" class=\"wp-image-409\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/olegberezevski.wordpress.com\/wp-content\/uploads\/2026\/03\/image-14.png?w=597\" alt=\"\" class=\"wp-image-410\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">proceduur mis ei t\u00f6\u00f6ta korrektselt. tulemuses annab \u00fcks ja sama nimi<br>peame lisama<strong> where<\/strong> \u2026<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate proc spGetnameById\n@Id int,\n@Name nvarchar(20) output\nas begin\n\tselect @Id = Id, @Name = Name from Employees \nend\n\nselect * from Employees\ndeclare @FirstName nvarchar(50)\nexecute spGetnameById 3, @FirstName output\nprint &#039;Name of the employee = &#039; + @FirstName\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>1. Video protseduurid Oma 2 protseduurid 3 jaoks Oma 2 protseduurid 4 jaoks Protseduur mis kuvab Product manufacturer ja price Protseduur mis lisab uus produkt Protsedure ilma kasutava parametriga Protseduur koos OUTPUT parametriga S\u00fcsteemi protseduurid proceduur mis ei t\u00f6\u00f6ta korrektselt. tulemuses annab \u00fcks ja sama nimipeame lisama where \u2026<\/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-369","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/pages\/369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/comments?post=369"}],"version-history":[{"count":0,"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/pages\/369\/revisions"}],"wp:attachment":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/media?parent=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}