{"id":976,"date":"2023-06-08T12:21:46","date_gmt":"2023-06-08T12:21:46","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=976"},"modified":"2023-06-08T12:30:15","modified_gmt":"2023-06-08T12:30:15","slug":"andmetuupide-loomine","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/andmetuupide-loomine\/","title":{"rendered":"Andmet\u00fc\u00fcpide loomine"},"content":{"rendered":"\n<p>Andmet\u00fc\u00fcpide loomiseks on vaja andmebaasi programmeerimisobjektide alt \u00fclesse otsida Types\\Use-defined Data Types ning lisada sinna uus:<\/p>\n\n\n\n<p>Andmet\u00fc\u00fcbi loomisel saate \u00e4ra m\u00e4\u00e4rata uue andmet\u00fc\u00fcbi nime, s\u00fcsteemse andmet\u00fc\u00fcbi, millele uus andmet\u00fc\u00fcp baseerub, kas vaikimisi lubatakse m\u00e4\u00e4ramata v\u00e4\u00e4rtusi v\u00f5i mitte ning milliseid reegleid rakendatakse. Reeglitest r\u00e4\u00e4gime pisut hiljem.<\/p>\n\n\n\n<p>Kogu selle t\u00f6\u00f6 saab \u00e4ra teha ka lihtsa SQL Lausega:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TYPE &#x5B;dbo].&#x5B;Aasta] FROM &#x5B;smallint] NOT NULL\n<\/pre><\/div>\n\n\n<p>Uue tabeli loomisel saame oma tehtud andmet\u00fc\u00fcpi kasutada nagu s\u00fcsteemsetki. Kui soovime n\u00fc\u00fcd tagantj\u00e4rele olemasolevates tabelites asenduse teha siis on olukord keerulisem kuna SQL Server selliseid asendusi ei luba. Selle asenduse saame aga teha v\u00e4ikese skriptiga, mis esmalt loob uue v\u00e4lja, seej\u00e4rel kopeerib k\u00f5ik andmed vanalt v\u00e4ljalt uuele ning kustutab vana v\u00e4lja.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER TABLE dbo.Auto_tbl\nADD tmp_Aasta dbo.Aasta\nGO\nUPDATE dbo.Auto_tbl\nSET tmp_Aasta = Aasta\nALTER TABLE dbo.Auto_tbl\nDROP COLUMN Aasta\nGO\nEXECUTE sp_rename N&#039;dbo.Auto_tbl.tmp_Aasta&#039;, N&#039;Aasta&#039;, &#039;COLUMN&#039; \nGO\n<\/pre><\/div>\n\n\n<p>Isetehtud andmet\u00fc\u00fcbid v\u00f5imaldavad lihtsama vaevaga \u00fchtlustada\/hoida \u00fchtsena sarnaste tunnustega andmete salvestamise.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><a><\/a>Andmete \u00fchtsuse tagamine<\/h4>\n\n\n\n<p>Andmete \u00fchtsuse tagamiseks on SQL serveris mitmeid v\u00f5imalusi:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>andmet\u00fc\u00fcbid<\/li>\n\n\n\n<li>konstraandid e. piirangud<\/li>\n\n\n\n<li>indeksid<\/li>\n\n\n\n<li>v\u00f5tmed<\/li>\n\n\n\n<li>triggerid e. p\u00e4\u00e4stikud<\/li>\n\n\n\n<li>programsed vahendid<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Andmet\u00fc\u00fcpide loomiseks on vaja andmebaasi programmeerimisobjektide alt \u00fclesse otsida Types\\Use-defined Data Types ning lisada sinna uus: Andmet\u00fc\u00fcbi loomisel saate \u00e4ra m\u00e4\u00e4rata uue andmet\u00fc\u00fcbi nime, s\u00fcsteemse andmet\u00fc\u00fcbi, millele uus andmet\u00fc\u00fcp baseerub, kas vaikimisi lubatakse m\u00e4\u00e4ramata v\u00e4\u00e4rtusi v\u00f5i mitte ning milliseid reegleid rakendatakse. Reeglitest r\u00e4\u00e4gime pisut hiljem. Kogu selle t\u00f6\u00f6 saab \u00e4ra teha ka lihtsa SQL Lausega: &hellip; <a href=\"https:\/\/tarkvara.thkit.ee\/veeb\/andmetuupide-loomine\/\" class=\"more-link\">Loe edasi <span class=\"screen-reader-text\">Andmet\u00fc\u00fcpide loomine<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/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-976","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/comments?post=976"}],"version-history":[{"count":15,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/976\/revisions"}],"predecessor-version":[{"id":1001,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/976\/revisions\/1001"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}