{"version":"1.0","provider_name":"Artjom P&otilde;ldsaar Portfoolio","provider_url":"https:\/\/artjompoldsaar24.thkit.ee\/wp","author_name":"admin","author_url":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/blog\/author\/admin\/","title":"SQL Transaktsioonid - Artjom P&otilde;ldsaar Portfoolio","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"yw9o1ya4I1\"><a href=\"https:\/\/artjompoldsaar24.thkit.ee\/wp\/sql-transaktsioonid\/\">SQL Transaktsioonid<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/artjompoldsaar24.thkit.ee\/wp\/sql-transaktsioonid\/embed\/#?secret=yw9o1ya4I1\" width=\"600\" height=\"338\" title=\"&#8220;SQL Transaktsioonid&#8221; &#8212; Artjom P&otilde;ldsaar Portfoolio\" data-secret=\"yw9o1ya4I1\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/artjompoldsaar24.thkit.ee\/wp\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"\u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043a\u043e\u043d\u0446\u0435\u043f\u0446\u0438\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0442\u0441\u044f \u0430\u0431\u0431\u0440\u0435\u0432\u0438\u0430\u0442\u0443\u0440\u043e\u0439 ACID \u2013 Transaktsiooni Haldumine Transaktsioonid SQL Serveris Transaktsioonid XAMPPis ROLLBACK; SAVEPOINT \u00dclesanne L\u00fclitame autocommit v\u00e4lja, n\u00fc\u00fcd me peame COMMIT teha et transaktsiooni teha. Kustutame k\u00f5ik arendajad kelle SPECIALTY on C++, ja v\u00f5tame seda tagasi. Video Konspekt hinne 5 &#8211; https:\/\/www.youtube.com\/watch?v=shkt9Z5Gz-U Muudame 1 Product ja paneme QtyAvailable 200 V\u00f5tame tagasi N\u00fc\u00fcd meil on 2 uud tabelid, ja sellel on viga London nimega. Kirjutame protseduur, mis parandab linna nimi, ja kasutame transaktsioonid ja TRY CATCH et veod tabada. Muudame see protseduur ja teeme vigu meelega. N\u00e4itame et kaks muudatused oli tagastatud."}