{"id":357,"date":"2026-03-19T15:29:46","date_gmt":"2026-03-19T13:29:46","guid":{"rendered":"https:\/\/mihkelunt.wordpress.com\/?page_id=357"},"modified":"2026-03-19T15:29:46","modified_gmt":"2026-03-19T13:29:46","slug":"protseduurid","status":"publish","type":"page","link":"https:\/\/mihkelunt.eu\/wp\/andmebaasid\/protseduurid\/","title":{"rendered":"Protseduurid"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Union <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/7679263c-ea6d-49e8-83ac-1fde686b4003.png?w=553\" alt=\"\" class=\"wp-image-358\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/5e302f7c-ec0e-4706-8b16-320db5c65520.png?w=673\" alt=\"\" class=\"wp-image-360\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/57e7dbdb-e923-4cf1-80e4-d8fc62828c41.png?w=836\" alt=\"\" class=\"wp-image-362\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Prosteduuri salvestamine ja v\u00e4lja kutsumine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/55373164-b588-4341-af42-54bf9504f0fd.png?w=520\" alt=\"\" class=\"wp-image-364\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Protseduur kriteeriumitega <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/dffd27eb-4ac8-4407-96da-570a5989e969.png?w=909\" alt=\"\" class=\"wp-image-366\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">See protseduur n\u00e4itab tabeli sisu parametriga kus sugu = &#8216;Male&#8217; ja DeptartmentID = 1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sp helptext n\u00e4itab protseduuri sisu <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/a096b5d2-7a04-47f8-9fb8-10f0df64ae93.png?w=655\" alt=\"\" class=\"wp-image-368\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Protseduuri kriptimine ehk kaitsmine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/5c4dad11-cab3-4a60-a2e7-4f9b1594102e.png?w=1024\" alt=\"\" class=\"wp-image-370\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Protseduur kus n\u00e4itab palju on Male employees<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/effde542-31bd-4b44-be07-0b159693f294.png?w=942\" alt=\"\" class=\"wp-image-372\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e4itab protseduuri <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/0e54b62d-454e-4314-b516-fc20914bb731.png?w=869\" alt=\"\" class=\"wp-image-374\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Lihtsam variant ilma print texti <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/02c47f37-330f-453e-8212-19b00e3c3d94.png?w=1024\" alt=\"\" class=\"wp-image-376\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">sp sisu vaatamine<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sp_help spGetEmployeeCountByGender<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/c0c20d3e-c446-497b-ab02-500e7db8971d.png?w=680\" alt=\"\" class=\"wp-image-378\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">tabeli info N\u00e4itmine <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sp_help Employees2<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/04981830-1434-4400-bd24-64865aa49719.png?w=926\" alt=\"\" class=\"wp-image-380\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">kui soovid sp tektsi n\u00e4ha<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sp_helptext spGetEmployeeCountByGender<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/ca70b171-f180-4037-a41e-0745b7e7fc9f.png?w=378\" alt=\"\" class=\"wp-image-382\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">vaatame , millest see sp s\u00f5ltub<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sp_depends spGetEmployeeCountByGender<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/ed3d086a-e60f-4736-97dd-a3e4bf672201.png?w=381\" alt=\"\" class=\"wp-image-384\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e4itab millest s\u00f5ltub tabel<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sp_depends Employees2<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/72a7d9ed-8924-46d1-86c8-a6d9f3166fa4.png?w=472\" alt=\"\" class=\"wp-image-386\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Nii ei tohi return teha !!!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/84c1325e-f4d3-4f45-bf5b-d0726e0f2a18.png?w=746\" alt=\"\" class=\"wp-image-388\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">ASCII Funktsioonid<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/0e561754-9f6b-4057-a168-d8eaf5e691ff.png?w=558\" alt=\"\" class=\"wp-image-390\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select ascii n\u00e4itab valitud t\u00e4he numbrilist v\u00e4\u00e4rtust<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select char n\u00e4itab valitud numbri t\u00e4he <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kogu t\u00e4hestiku vaatamine :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/5607b5fe-9448-407c-a7a3-3a91558898df.png?w=418\" alt=\"\" class=\"wp-image-392\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>--keerab kooloni sees olevad andmed vastupidiseks\n-- vastavalt upper ja lower-ga saan muuta m\u00e4rkide suurust\n-- reverse funktsioon p\u00f6\u00f6rab k\u00f5ik \u00fcmber\nselect REVERSE(UPPER(ltrim(Name))) as FirstName, lower(Gender) as Gender,\nrtrim(ltrim(Name)) + &#039; &#039; + Gender as FullInfo\nfrom Employees2<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>--n\u00e4eb, mitu t\u00e4hte on s\u00f5nal ja loeb t\u00fchikud sisse\nselect Name, len(Name) as &#091;Total Characters] from Employees2<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>--kuvab @-t\u00e4hem\u00e4rgi asetust e mitmes on @ m\u00e4rk\nselect charindex(&#039;@&#039;, &#039;sara@aaa.com&#039;)\n\n\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>--- @-m\u00e4rgist kuvab kolm t\u00e4hem\u00e4rki. Viimase numriga saab m\u00e4\u00e4rata pikkust\nselect substring(&#039;pam@bb.com&#039;, charindex(&#039;@&#039;, &#039;pam@bb.com&#039;) + 1, 3)<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>--- peale @-m\u00e4rki reguleerin t\u00e4hem\u00e4rkide pikkuse n\u00e4itamist\nselect substring(&#039;pam@bb.com&#039;, charindex(&#039;@&#039;, &#039;pam@bb.com&#039;) + 1, \nlen(&#039;pam@bb.com&#039;) - CHARINDEX(&#039;@&#039;, &#039;pam@bb.com&#039;))<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Lisasime tabelisse Email veerg<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/d4cb8d42-795e-4362-8e31-1e822c21836b.png?w=776\" alt=\"\" class=\"wp-image-399\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">lisame *-m\u00e4rgi alates teatud kohast<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/c3195d67-4e2c-4a5d-aac5-910984e5a7c1.png?w=1024\" alt=\"\" class=\"wp-image-401\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">&#8212; kolm korda n\u00e4itab stringis olevat v\u00e4\u00e4rtust<br>&#8211;dubleerib nimi kolm korda<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/fc4b98c7-1f6e-4718-820e-3d8fa563ffec.png?w=346\" alt=\"\" class=\"wp-image-403\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">&#8211;Employees tabelist teed p\u00e4ringu kahe nime osas (FirstName ja LastName)<br>&#8211;kahe nime vahel on 25 t\u00fchikut<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mihkelunt.wordpress.com\/wp-content\/uploads\/2026\/03\/e9556f2c-4ea5-40b2-b2ac-72e9b7ebcf1e.png?w=583\" alt=\"\" class=\"wp-image-405\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Union Prosteduuri salvestamine ja v\u00e4lja kutsumine Protseduur kriteeriumitega See protseduur n\u00e4itab tabeli sisu parametriga kus sugu = &#8216;Male&#8217; ja DeptartmentID = 1 Sp helptext n\u00e4itab protseduuri sisu Protseduuri kriptimine ehk kaitsmine Protseduur kus n\u00e4itab palju on Male employees N\u00e4itab protseduuri Lihtsam variant ilma print texti sp sisu vaatamine tabeli info N\u00e4itmine kui soovid sp tektsi [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":120,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-357","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/pages\/357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/comments?post=357"}],"version-history":[{"count":0,"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/pages\/357\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/pages\/120"}],"wp:attachment":[{"href":"https:\/\/mihkelunt.eu\/wp\/wp-json\/wp\/v2\/media?parent=357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}