{"id":816,"date":"2025-05-14T07:39:01","date_gmt":"2025-05-14T07:39:01","guid":{"rendered":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816"},"modified":"2025-05-14T10:23:45","modified_gmt":"2025-05-14T10:23:45","slug":"sql-transaktsioonid","status":"publish","type":"page","link":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816","title":{"rendered":"SQL transaktsioonid"},"content":{"rendered":"\n<p><strong>\u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f &#8211; <\/strong>\u044d\u0442\u043e \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u0445 \u0432 \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u043f\u043e\u0440\u044f\u0434\u043a\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c, \u043b\u0438\u0431\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043e\u0439, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0441 \u0411\u0414.<\/p>\n\n\n\n<p><strong>\u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f<\/strong>&nbsp;\u2013 \u044d\u0442\u043e \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u0411\u0414. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u043b\u0438 \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u0451\u043c, \u0438\u0437\u043c\u0435\u043d\u044f\u0435\u043c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u044f\u0435\u043c \u0437\u0430\u043f\u0438\u0441\u044c, \u0442\u043e \u043c\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e. \u041a\u0440\u0430\u0439\u043d\u0435 \u0432\u0430\u0436\u043d\u043e \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f.<\/p>\n\n\n\n<p>\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&nbsp;<strong>ACID&nbsp;<\/strong>\u2013<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A<\/strong>tomicity &#8211;\u00a0\u0410\u0442\u043e\u043c\u0430\u0440\u043d\u043e\u0441\u0442\u044c<\/li>\n\n\n\n<li><strong>C<\/strong>onsistency &#8211;\u00a0\u0421\u043e\u0433\u043b\u0430\u0441\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c<\/li>\n\n\n\n<li><strong>I<\/strong>solation &#8211;\u00a0\u0418\u0437\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c<\/li>\n\n\n\n<li><strong>D<\/strong>urability &#8211; \u0414\u043e\u043b\u0433\u043e\u0432\u0435\u0447\u043d\u043e\u0441\u0442\u044c<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u0410\u0442\u043e\u043c\u0430\u0440\u043d\u043e\u0441\u0442\u044c<\/h2>\n\n\n\n<p>\u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e \u043b\u044e\u0431\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0431\u0443\u0434\u0435\u0442 \u0437\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u0430 \u0442\u043e\u043b\u044c\u043a\u043e \u0446\u0435\u043b\u0438\u043a\u043e\u043c (\u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e). \u0415\u0441\u043b\u0438 \u043e\u0434\u043d\u0430 \u0438\u0437 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439 \u0432 \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0430, \u0442\u043e \u0432\u0441\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0431\u0443\u0434\u0435\u0442 \u043e\u0442\u043c\u0435\u043d\u0435\u043d\u0430. \u0422\u0443\u0442 \u0432\u0432\u043e\u0434\u0438\u0442\u0441\u044f \u043f\u043e\u043d\u044f\u0442\u0438\u0435 \u201c\u043e\u0442\u043a\u0430\u0442\u0430\u201d (rollback). \u0422.\u0435. \u0432\u043d\u0443\u0442\u0440\u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0431\u0443\u0434\u0443\u0442 \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f, \u043d\u043e \u043f\u043e \u0438\u0442\u043e\u0433\u0443 \u0432\u0441\u0435 \u043e\u043d\u0438 \u0431\u0443\u0434\u0443\u0442 \u043e\u0442\u043c\u0435\u043d\u0435\u043d\u044b (\u201c\u043e\u0442\u043a\u0430\u0447\u0435\u043d\u044b\u201d) \u0438 \u043f\u043e \u0438\u0442\u043e\u0433\u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0435 \u0443\u0432\u0438\u0434\u0438\u0442 \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0421\u043e\u0433\u043b\u0430\u0441\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c<\/h2>\n\n\n\n<p>\u0421\u043e\u0433\u043b\u0430\u0441\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c \u043e\u0437\u043d\u0430\u0447\u0430\u0435\u0442, \u0447\u0442\u043e \u043b\u044e\u0431\u0430\u044f \u0437\u0430\u0432\u0435\u0440\u0448\u0451\u043d\u043d\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f (\u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0434\u043e\u0441\u0442\u0438\u0433\u043b\u0430 \u0437\u0430\u0432\u0435\u0440\u0448\u0435\u043d\u0438\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u2013 end of transaction) \u0444\u0438\u043a\u0441\u0438\u0440\u0443\u0435\u0442 \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043e\u043f\u0443\u0441\u0442\u0438\u043c\u044b\u0435 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043f\u0440\u0438 \u043f\u0435\u0440\u0435\u0432\u043e\u0434\u0435 \u0434\u0435\u043d\u0435\u0433 \u0441 \u043e\u0434\u043d\u043e\u0433\u043e \u0441\u0447\u0451\u0442\u0430 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u0439, \u0432 \u0441\u043b\u0443\u0447\u0430\u0435, \u0435\u0441\u043b\u0438 \u0434\u0435\u043d\u044c\u0433\u0438 \u0443\u0448\u043b\u0438 \u0441 \u043e\u0434\u043d\u043e\u0433\u043e \u0441\u0447\u0451\u0442\u0430, \u043e\u043d\u0438 \u0434\u043e\u043b\u0436\u043d\u044b \u043f\u0440\u0438\u0439\u0442\u0438 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u0439 (\u044d\u0442\u043e \u0438 \u0435\u0441\u0442\u044c \u0441\u043e\u0433\u043b\u0430\u0441\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u044b). \u0421\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0438 \u0437\u0430\u0447\u0438\u0441\u043b\u0435\u043d\u0438\u0435&nbsp; \u2013 \u044d\u0442\u043e \u0434\u0432\u0435 \u0440\u0430\u0437\u043d\u044b\u0435 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u043f\u0435\u0440\u0432\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u043f\u0440\u043e\u0439\u0434\u0451\u0442 \u0431\u0435\u0437 \u043e\u0448\u0438\u0431\u043e\u043a, \u0430 \u0432\u0442\u043e\u0440\u043e\u0439 \u043f\u0440\u043e\u0441\u0442\u043e \u043d\u0435 \u0431\u0443\u0434\u0435\u0442. \u0418\u043c\u0435\u043d\u043d\u043e \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u043a\u0440\u0430\u0439\u043d\u0435 \u0432\u0430\u0436\u043d\u043e \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u0442\u044c \u044d\u0442\u043e \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u043e \u0438 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0442\u044c \u0431\u0430\u043b\u0430\u043d\u0441 \u0441\u0438\u0441\u0442\u0435\u043c\u044b.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0418\u0437\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c<\/h2>\n\n\n\n<p>\u041a\u0430\u0436\u0434\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0434\u043e\u043b\u0436\u043d\u0430 \u0431\u044b\u0442\u044c \u0438\u0437\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u0430 \u043e\u0442 \u0434\u0440\u0443\u0433\u0438\u0445, \u0442.\u0435. \u0435\u0451 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u043d\u0435 \u0434\u043e\u043b\u0436\u0435\u043d \u0437\u0430\u0432\u0438\u0441\u0435\u0442\u044c \u043e\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0434\u0440\u0443\u0433\u0438\u0445 \u043f\u0430\u0440\u0430\u043b\u043b\u0435\u043b\u044c\u043d\u044b\u0445 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0439. \u041d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0435, \u0438\u0437\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c \u043a\u0440\u0430\u0439\u043d\u0435 \u0442\u0440\u0443\u0434\u043d\u043e\u0434\u043e\u0441\u0442\u0438\u0436\u0438\u043c\u0430\u044f \u0432\u0435\u0449\u044c, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0437\u0434\u0435\u0441\u044c \u0432\u0432\u043e\u0434\u0438\u0442\u0441\u044f \u043f\u043e\u043d\u044f\u0442\u0438\u0435 \u201c\u0443\u0440\u043e\u0432\u043d\u0438 \u0438\u0437\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u0438\u201d (\u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0438\u0437\u043e\u043b\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043d\u0435 \u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0414\u043e\u043b\u0433\u043e\u0432\u0435\u0447\u043d\u043e\u0441\u0442\u044c<\/h2>\n\n\n\n<p>\u042d\u0442\u0430 \u043a\u043e\u043d\u0446\u0435\u043f\u0446\u0438\u044f \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e \u0435\u0441\u043b\u0438 \u043c\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u0438 \u043f\u043e\u0434\u0442\u0432\u0435\u0440\u0436\u0434\u0435\u043d\u0438\u0435 \u043e \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438, \u0442\u043e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f, \u0432\u044b\u0437\u0432\u0430\u043d\u043d\u044b\u0435 \u044d\u0442\u043e\u0439 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0435\u0439 \u043d\u0435 \u0434\u043e\u043b\u0436\u043d\u044b \u0431\u044b\u0442\u044c \u043e\u0442\u043c\u0435\u043d\u0435\u043d\u044b \u0438\u0437-\u0437\u0430 \u0441\u0431\u043e\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u044b (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043e\u0442\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043f\u0438\u0442\u0430\u043d\u0438\u044f).<\/p>\n\n\n\n<p><em><strong>\u0414\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043a\u043e\u043c\u0430\u043d\u0434\u044b:<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>COMMIT<\/strong><br>\u0421\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u0442 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f<\/li>\n\n\n\n<li><strong>ROLLBACK<\/strong><br>\u041e\u0442\u043a\u0430\u0442\u044b\u0432\u0430\u0435\u0442 (\u043e\u0442\u043c\u0435\u043d\u044f\u0435\u0442) \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f<\/li>\n\n\n\n<li><strong>SAVEPOINT<\/strong><br>\u0421\u043e\u0437\u0434\u0430\u0451\u0442 \u0442\u043e\u0447\u043a\u0443 \u043a \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0433\u0440\u0443\u043f\u043f\u0430 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0439 \u043c\u043e\u0436\u0435\u0442 \u043e\u0442\u043a\u0430\u0442\u0438\u0442\u044c\u0441\u044f<\/li>\n\n\n\n<li><strong>SET TRANSACTION<\/strong><br>\u0420\u0430\u0437\u043c\u0435\u0449\u0430\u0435\u0442 \u0438\u043c\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438.<\/li>\n<\/ul>\n\n\n\n<p>\u041a\u043e\u043c\u0430\u043d\u0434\u044b \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043b\u044f DML \u043a\u043e\u043c\u0430\u043d\u0434: INSERT, UPDATE, DELETE. \u041e\u043d\u0438 \u043d\u0435 \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u044b \u0432\u043e \u0432\u0440\u0435\u043c\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f, \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b.<\/p>\n\n\n\n<p>\u041b\u044e\u0431\u043e\u0435 \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439&nbsp;<strong>COMMIT<\/strong>&nbsp;(\u0444\u0438\u043a\u0441\u0430\u0446\u0438\u044f), \u0432 \u0442\u043e \u0432\u0440\u0435\u043c\u044f \u043a\u0430\u043a \u043d\u0435\u0443\u0434\u0430\u0447\u043d\u043e\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0434\u043e\u043b\u0436\u043d\u043e \u0431\u044b\u0442\u044c \u0437\u0430\u043a\u043e\u043d\u0447\u0435\u043d\u043e \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439&nbsp;<strong>ROLLBACK&nbsp;<\/strong>(\u043e\u0442\u043a\u0430\u0442), \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u0442 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f, \u0432\u043d\u0435\u0441\u0435\u043d\u043d\u044b\u0435 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0435\u0439.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE DATABASE transactionTARgv24;\nuse transactionTARgv24;\n\nCREATE TABLE T(\nid int not null Primary key,\ns varchar(40),\nsi smallint);\n\nINSERT INTO T(id, s) VALUES(1, &#039;First&#039;);\nINSERT INTO T(id, s) VALUES(2, &#039;Second&#039;);\nINSERT INTO T(id, s) VALUES(3, &#039;Third&#039;);\n\nSELECT * FROM T;\n\n--tagasi v\u00f5tmine\nROLLBACK;\n--alustame transaktsioon\nBEGIN TRANSACTION;\nINSERT INTO T(id, s) VALUES(4, &#039;Fourth&#039;);\nSELECT * FROM T;\n--tagasi v\u00f5tmine\nROLLBACK;\nSELECT * FROM T;\n\nBEGIN TRANSACTION;\nDELETE FROM T WHERE id &gt; 1;\nSELECT * FROM T;\n\nROLLBACK;\nSELECT * FROM T\n\n--transaktion mis salvestab uuendamine ja v\u00f5tab tagasi\nBEGIN TRANSACTION;\nUPDATE T SET si=3;\nSELECT * FROM T;\nROLLBACK;\nSELECT * FROM T;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"521\" height=\"645\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2.png\" alt=\"\" class=\"wp-image-821\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2.png 521w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2-242x300.png 242w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2-121x150.png 121w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u0437\u0430\u0434\u0430\u043d\u0438\u044f \u043f\u043e \u0432\u0438\u0434\u0435\u043e<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Transactions in sql server   Part 57\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/shkt9Z5Gz-U?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE tblProduct\n(\n ProcutID int NOT NULL primary key,\n Name nvarchar(40),\n UnitPrice int,\n QtyAvailable int,\n)\n\nINSERT INTO tblProduct VALUES (1, &#039;Laptop&#039;, &#039;1000&#039;, 10);\nINSERT INTO tblProduct VALUES (2, &#039;Mouse&#039;, &#039;100&#039;, 20)\n\nSELECT * FROM tblProduct\n\nBEGIN TRANSACTION\nUPDATE tblProduct SET QtyAvailable 5 WHERE ProcutID = 1\nSELECT * FROM tblProduct\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"391\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-3.png\" alt=\"\" class=\"wp-image-826\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-3.png 563w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-3-300x208.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-3-150x104.png 150w\" sizes=\"auto, (max-width: 563px) 100vw, 563px\" \/><\/figure>\n\n\n\n<p>\u0414\u043e\u043f\u0443\u0441\u0442\u0438\u043b \u043e\u043f\u0435\u0447\u0430\u0442\u043a\u0443 \u043f\u0435\u0440\u0435\u0438\u043c\u0435\u043d\u043e\u0432\u044b\u0432\u0430\u044e \u0441\u0442\u043e\u043b\u0431\u0435\u0446 <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nEXEC sp_rename &#039;tblProduct.ProcutID&#039;, &#039;ProductID&#039;, &#039;COLUMN&#039;;\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN TRANSACTION  -- \u041d\u0430\u0447\u0438\u043d\u0430\u0435\u043c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e\n\n-- \u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u043d\u043e\u0443\u0442\u0431\u0443\u043a\u043e\u0432 \u0434\u043e 5\nUPDATE tblProduct \nSET QtyAvailable = 5 \nWHERE ProductID = 1;\n\n-- \u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f\nSELECT * FROM tblProduct;\n\n-- \u0417\u0430\u0432\u0435\u0440\u0448\u0430\u0435\u043c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e, \u0444\u0438\u043a\u0441\u0438\u0440\u0443\u0435\u043c \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f\nCOMMIT;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"472\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-4.png\" alt=\"\" class=\"wp-image-827\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-4.png 692w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-4-300x205.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-4-150x102.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-4-600x409.png 600w\" sizes=\"auto, (max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<p>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED<\/p>\n\n\n\n<p>\u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u0442 <strong>\u0443\u0440\u043e\u0432\u0435\u043d\u044c \u0438\u0437\u043e\u043b\u044f\u0446\u0438\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438<\/strong> \u043d\u0430 <code>READ UNCOMMITTED<\/code>, \u0447\u0442\u043e \u043e\u0437\u043d\u0430\u0447\u0430\u0435\u0442:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0420\u0430\u0437\u0440\u0435\u0448\u0435\u043d\u043e <strong>\u0447\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0435\u0449\u0451 \u043d\u0435 \u0437\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u044b<\/strong> \u0434\u0440\u0443\u0433\u0438\u043c\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f\u043c\u0438.<\/li>\n\n\n\n<li>\u0422\u0430\u043a\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043d\u0430\u0437\u044b\u0432\u0430\u044e\u0442\u0441\u044f <strong>&#8220;\u0433\u0440\u044f\u0437\u043d\u044b\u043c\u0438&#8221; (dirty reads)<\/strong>.<\/li>\n\n\n\n<li>\u042d\u0442\u043e <strong>\u0441\u0430\u043c\u044b\u0439 \u043d\u0438\u0437\u043a\u0438\u0439<\/strong> \u0443\u0440\u043e\u0432\u0435\u043d\u044c \u0438\u0437\u043e\u043b\u044f\u0446\u0438\u0438 \u2014 \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0438\u0432\u0435\u0441\u0442\u0438 \u043a \u043d\u0435\u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u044b\u043c \u0438\u043b\u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u043c \u0434\u0430\u043d\u043d\u044b\u043c.<\/li>\n<\/ul>\n\n\n\n<p> \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f, \u043a\u043e\u0433\u0434\u0430 <strong>\u0432\u0430\u0436\u043d\u0430 \u0441\u043a\u043e\u0440\u043e\u0441\u0442\u044c<\/strong>, \u0430 <strong>\u0442\u043e\u0447\u043d\u043e\u0441\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0435 \u043a\u0440\u0438\u0442\u0438\u0447\u043d\u0430<\/strong> (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0432 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0435).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \/ \u043e\u0442\u043a\u0430\u0442<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN TRANSACTION\n\nUPDATE tblProduct \nSET QtyAvailable = QtyAvailable - 1 \nWHERE ProductID = 1;\nSELECT * FROM tblProduct;\n-- \u041e\u0442\u043a\u0430\u0442 \u0432\u0441\u0435\u0445 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439\nROLLBACK TRANSACTION;\n\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"312\" height=\"115\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-5.png\" alt=\"\" class=\"wp-image-830\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-5.png 312w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-5-300x111.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-5-150x55.png 150w\" sizes=\"auto, (max-width: 312px) 100vw, 312px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nROLLBACK TRANSACTION;\nSELECT * FROM tblProduct;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"316\" height=\"264\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6.png\" alt=\"\" class=\"wp-image-831\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6.png 316w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6-300x251.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6-150x125.png 150w\" sizes=\"auto, (max-width: 316px) 100vw, 316px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">2 \u0447\u0430\u0441\u0442\u044c \u0432\u0438\u0434\u0435\u043e<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCreate Table tblMailingAddress\n(\n   AddressId int NOT NULL primary key,\n   EmployeeNumber int,\n   HouseNumber nvarchar(50),\n   StreetAddress nvarchar(50),\n   City nvarchar(10),\n   PostalCode nvarchar(50)\n)\n\nInsert into tblMailingAddress values (1, 101, &#039;#10&#039;, &#039;King Street&#039;, &#039;Londoon&#039;, &#039;CR27DW&#039;)\n\nCreate Table tblPhysicalAddress\n(\n AddressId int NOT NULL primary key,\n EmployeeNumber int,\n HouseNumber nvarchar(50),\n StreetAddress nvarchar(50),\n City nvarchar(10),\n PostalCode nvarchar(50)\n)\n\nInsert into tblPhysicalAddress values (1, 101, &#039;#10&#039;, &#039;King Street&#039;, &#039;Londoon&#039;, &#039;CR27DW&#039;)\n\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE PROCEDURE spUpdateAddress\nAS\nBEGIN\n    BEGIN TRY\n        BEGIN TRANSACTION\n\n        -- \u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u043f\u043e\u043b\u0435 City \u0432 \u043f\u043e\u0447\u0442\u043e\u0432\u043e\u043c \u0430\u0434\u0440\u0435\u0441\u0435\n        UPDATE tblMailingAddress \n        SET City = &#039;LONDON&#039; \n        WHERE AddressId = 1 AND EmployeeNumber = 101\n\n        -- \u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u043f\u043e\u043b\u0435 City \u0432 \u0444\u0438\u0437\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u0430\u0434\u0440\u0435\u0441\u0435\n        UPDATE tblPhysicalAddress \n        SET City = &#039;LONDON&#039; \n        WHERE AddressId = 1 AND EmployeeNumber = 101\n\n        COMMIT TRANSACTION\n        PRINT &#039;Transaction committed&#039; -- \u041f\u043e\u0434\u0442\u0432\u0435\u0440\u0436\u0434\u0435\u043d\u0438\u0435 \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u0433\u043e \u0437\u0430\u0432\u0435\u0440\u0448\u0435\u043d\u0438\u044f\n    END TRY\n    BEGIN CATCH\n        ROLLBACK TRANSACTION\n        PRINT &#039;Transaction rolled back&#039;  -- \u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u043e\u0431 \u043e\u0442\u043a\u0430\u0442\u0435 \u043f\u0440\u0438 \u043e\u0448\u0438\u0431\u043a\u0435\n    END CATCH\nEND\n\n\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--\u0443\u0431\u0435\u0440\u0435\u043c \u043e\u043f\u0435\u0447\u0430\u0442\u043a\u0443 LONDOON\nUPDATE tblMailingAddress SET City = &#039;London&#039; WHERE AddressId = 1;\nUPDATE tblPhysicalAddress SET City = &#039;London&#039; WHERE AddressId = 1;\n\nSELECT * FROM tblMailingAddress\nSELECT * FROM tblPhysicalAddress\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"523\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7.png\" alt=\"\" class=\"wp-image-836\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7.png 609w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-300x258.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-150x129.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-600x515.png 600w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/figure>\n\n\n\n<p>\u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443, \u0434\u043e\u043b\u0436\u043d\u0430 \u0432\u044b\u0439\u0442\u0438 \u0438\u043d\u0444\u0430 &#8216;Transaction commited&#8217;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"417\" height=\"274\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8.png\" alt=\"\" class=\"wp-image-837\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8.png 417w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-300x197.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-150x99.png 150w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nAlter Procedure spUpdateAddress\nas\nBegin\n Begin Try\n  Begin Transaction\n   Update tblMailingAddress set City = &#039;LONDON-LONDON&#039; \n   where AddressId = 1 and EmployeeNumber = 101\n   \n   Update tblPhysicalAddress set City = &#039;LONDON2&#039; \n   where AddressId = 1 and EmployeeNumber = 101\n  Commit Transaction\n  Print &#039;Transaction committed&#039;\n End Try\n Begin Catch\n  Rollback Transaction\n  print &#039;Transaction Rolled back&#039;\n End Catch\nEnd\n\nSELECT * FROM tblMailingAddress\nSELECT * FROM tblPhysicalAddress\n\nEXEC spUpdateAddress;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"212\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9.png\" alt=\"\" class=\"wp-image-840\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9.png 482w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9-300x132.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9-150x66.png 150w\" sizes=\"auto, (max-width: 482px) 100vw, 482px\" \/><\/figure>\n\n\n\n<p>\u043f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 LONDON-LONDON \u0431\u043e\u043b\u0435\u0435 10\u0442\u0438 \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432 \u044d\u0442\u043e \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442 \u043e\u0448\u0438\u0431\u043a\u0443 (\u0443 \u043d\u0430\u0441 \u0443\u043a\u0430\u0437\u0430\u043d\u043e varchar10) <br>\u0442\u0435\u043c \u0441\u0430\u043c\u044b\u043c \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u043e\u0442\u043a\u0430\u0442 \u0431\u0435\u0437 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439. \u041e \u0447\u0435\u043c \u0441\u0432\u0438\u0434\u0435\u0442\u0435\u043b\u044c\u0441\u0442\u0432\u0443\u0435\u0442 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 Transaction Rolled Back<\/p>\n\n\n\n<p>\u0435\u0441\u043b\u0438 \u0437\u0430\u043c\u0435\u043d\u0438\u0442\u044c LONDON23 \/ LONDON25 \u0442\u043e \u0431\u0443\u0434\u0435\u0442 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f &#8211; \u0437\u0430\u043f\u0438\u0441\u044c \u0437\u0430\u043a\u043e\u043c\u0438\u0447\u0435\u043d\u0430<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nAlter Procedure spUpdateAddress\nas\nBegin\n Begin Try\n  Begin Transaction\n   Update tblMailingAddress set City = &#039;LONDON25&#039; \n   where AddressId = 1 and EmployeeNumber = 101\n   \n   Update tblPhysicalAddress set City = &#039;LONDON23&#039; \n   where AddressId = 1 and EmployeeNumber = 101\n  Commit Transaction\n  Print &#039;Transaction committed&#039;\n End Try\n Begin Catch\n  Rollback Transaction\n  print &#039;Transaction Rolled back&#039;\n End Catch\nEnd\n\nSELECT * FROM tblMailingAddress\nSELECT * FROM tblPhysicalAddress\n\nEXEC spUpdateAddress;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"160\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10.png\" alt=\"\" class=\"wp-image-841\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10.png 478w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-300x100.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-150x50.png 150w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"533\" height=\"283\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-11.png\" alt=\"\" class=\"wp-image-842\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-11.png 533w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-11-300x159.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-11-150x80.png 150w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">XAMPP<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u0435\u0440\u0432\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u0441 \u0442\u043e\u0432\u0430\u0440\u0430\u043c\u0438<\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0442\u043e\u0432\u0430\u0440\u043e\u0432\nCREATE TABLE tblProduct (\n    ProductID INT NOT NULL PRIMARY KEY,\n    Name VARCHAR(40),\n    UnitPrice INT,\n    QtyAvailable INT\n);\n\n-- \u0414\u043e\u0431\u0430\u0432\u0438\u043c \u0434\u0430\u043d\u043d\u044b\u0435\nINSERT INTO tblProduct VALUES (1, &#039;Laptop&#039;, 1000, 10);\nINSERT INTO tblProduct VALUES (2, &#039;Mouse&#039;, 100, 20);\n\n-- \u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c\nSELECT * FROM tblProduct;\n\n-- \u041d\u0430\u0447\u0438\u043d\u0430\u0435\u043c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e\nSTART TRANSACTION;\n\n-- \u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435\nUPDATE tblProduct \nSET QtyAvailable = 5 \nWHERE ProductID = 1;\n\n-- \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430\nSELECT * FROM tblProduct;\n\n-- \u0424\u0438\u043a\u0441\u0438\u0440\u0443\u0435\u043c\nCOMMIT;\n\n-- \u0414\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0430\u0446\u0438\u044f \u043e\u0442\u043a\u0430\u0442\u0430\nSTART TRANSACTION;\n\nUPDATE tblProduct \nSET QtyAvailable = QtyAvailable - 1 \nWHERE ProductID = 1;\n\nSELECT * FROM tblProduct;\n\n-- \u041e\u0442\u043a\u0430\u0442\nROLLBACK;\n\nSELECT * FROM tblProduct;\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"102\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12.png\" alt=\"\" class=\"wp-image-846\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12.png 631w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-300x48.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-150x24.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-600x97.png 600w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u0412\u0442\u043e\u0440\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u0441 \u0430\u0434\u0440\u0435\u0441\u0430\u043c\u0438<\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u0422\u0430\u0431\u043b\u0438\u0446\u044b \u0430\u0434\u0440\u0435\u0441\u043e\u0432\nCREATE TABLE tblMailingAddress (\n    AddressId INT PRIMARY KEY,\n    EmployeeNumber INT,\n    HouseNumber VARCHAR(50),\n    StreetAddress VARCHAR(50),\n    City VARCHAR(10),\n    PostalCode VARCHAR(50)\n);\n\nINSERT INTO tblMailingAddress \nVALUES (1, 101, &#039;#10&#039;, &#039;King Street&#039;, &#039;Londoon&#039;, &#039;CR27DW&#039;);\n\nCREATE TABLE tblPhysicalAddress (\n    AddressId INT PRIMARY KEY,\n    EmployeeNumber INT,\n    HouseNumber VARCHAR(50),\n    StreetAddress VARCHAR(50),\n    City VARCHAR(10),\n    PostalCode VARCHAR(50)\n);\n\nINSERT INTO tblPhysicalAddress \nVALUES (1, 101, &#039;#10&#039;, &#039;King Street&#039;, &#039;Londoon&#039;, &#039;CR27DW&#039;);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"336\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-1024x336.png\" alt=\"\" class=\"wp-image-850\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-1024x336.png 1024w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-300x98.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-768x252.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-150x49.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-600x197.png 600w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13.png 1452w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"987\" height=\"141\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14.png\" alt=\"\" class=\"wp-image-851\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14.png 987w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-300x43.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-768x110.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-150x21.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-600x86.png 600w\" sizes=\"auto, (max-width: 987px) 100vw, 987px\" \/><\/figure>\n\n\n\n<p>\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nDELIMITER \/\/\n\nCREATE PROCEDURE spUpdateAddress()\nBEGIN\n    START TRANSACTION;\n\n    UPDATE tblMailingAddress \n    SET City = &#039;LONDON25&#039; \n    WHERE AddressId = 1 AND EmployeeNumber = 101;\n\n    UPDATE tblPhysicalAddress \n    SET City = &#039;LONDON23&#039; \n    WHERE AddressId = 1 AND EmployeeNumber = 101;\n\n    COMMIT;\nEND;\n\/\/\n\nDELIMITER ;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"115\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-15.png\" alt=\"\" class=\"wp-image-852\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-15.png 540w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-15-300x64.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-15-150x32.png 150w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><\/figure>\n\n\n\n<p>\u0412\u044b\u0437\u044b\u0432\u0430\u0435\u043c \u0437\u0430\u0442\u0435\u043c \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c, \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0434\u043e\u043b\u0436\u043d\u044b \u043f\u043e\u043c\u0435\u043d\u044f\u0442\u0441\u044f \u043d\u0430 LONDON23\/LONDON25<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM tblMailingAddress;\nSELECT * FROM tblPhysicalAddress;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"934\" height=\"792\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/Hoiva.png\" alt=\"\" class=\"wp-image-853\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/Hoiva.png 934w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/Hoiva-300x254.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/Hoiva-768x651.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/Hoiva-150x127.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/Hoiva-600x509.png 600w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f &#8211; \u044d\u0442\u043e \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u0445 \u0432 \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u043f\u043e\u0440\u044f\u0434\u043a\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c, \u043b\u0438\u0431\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043e\u0439, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0441 \u0411\u0414. \u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f&nbsp;\u2013 \u044d\u0442\u043e \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u0411\u0414. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u043b\u0438 \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u0451\u043c, \u0438\u0437\u043c\u0435\u043d\u044f\u0435\u043c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u044f\u0435\u043c \u0437\u0430\u043f\u0438\u0441\u044c, \u0442\u043e \u043c\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e. \u041a\u0440\u0430\u0439\u043d\u0435 \u0432\u0430\u0436\u043d\u043e \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f. \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&nbsp;ACID&nbsp;\u2013 \u0410\u0442\u043e\u043c\u0430\u0440\u043d\u043e\u0441\u0442\u044c \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e \u043b\u044e\u0431\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0431\u0443\u0434\u0435\u0442 \u0437\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u0430 \u0442\u043e\u043b\u044c\u043a\u043e \u0446\u0435\u043b\u0438\u043a\u043e\u043c (\u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e). &#8230; <a title=\"SQL transaktsioonid\" class=\"read-more\" href=\"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816\" aria-label=\"Read more about SQL transaktsioonid\">Read more<\/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-816","page","type-page","status-publish"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL transaktsioonid - Gleb Dranitsyn \/ Portfolio<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL transaktsioonid - Gleb Dranitsyn \/ Portfolio\" \/>\n<meta property=\"og:description\" content=\"\u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f &#8211; \u044d\u0442\u043e \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u0445 \u0432 \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u043f\u043e\u0440\u044f\u0434\u043a\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c, \u043b\u0438\u0431\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043e\u0439, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0441 \u0411\u0414. \u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f&nbsp;\u2013 \u044d\u0442\u043e \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u0411\u0414. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u043b\u0438 \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u0451\u043c, \u0438\u0437\u043c\u0435\u043d\u044f\u0435\u043c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u044f\u0435\u043c \u0437\u0430\u043f\u0438\u0441\u044c, \u0442\u043e \u043c\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e. \u041a\u0440\u0430\u0439\u043d\u0435 \u0432\u0430\u0436\u043d\u043e \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f. \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&nbsp;ACID&nbsp;\u2013 \u0410\u0442\u043e\u043c\u0430\u0440\u043d\u043e\u0441\u0442\u044c \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e \u043b\u044e\u0431\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0431\u0443\u0434\u0435\u0442 \u0437\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u0430 \u0442\u043e\u043b\u044c\u043a\u043e \u0446\u0435\u043b\u0438\u043a\u043e\u043c (\u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e). ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816\" \/>\n<meta property=\"og:site_name\" content=\"Gleb Dranitsyn \/ Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-14T10:23:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"521\" \/>\n\t<meta property=\"og:image:height\" content=\"645\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816\",\"name\":\"SQL transaktsioonid - Gleb Dranitsyn \\\/ Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/image-2.png\",\"datePublished\":\"2025-05-14T07:39:01+00:00\",\"dateModified\":\"2025-05-14T10:23:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816#primaryimage\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/image-2.png\",\"contentUrl\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/image-2.png\",\"width\":521,\"height\":645},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=816#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL transaktsioonid\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\",\"name\":\"Gleb Dranitsyn \\\/ Portfolio\",\"description\":\"Tarkvara aarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Gleb Dranitsyn \\\/ Portfolio\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-cropped-logo1.jpg\",\"contentUrl\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-cropped-logo1.jpg\",\"width\":400,\"height\":171,\"caption\":\"Gleb Dranitsyn \\\/ Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL transaktsioonid - Gleb Dranitsyn \/ Portfolio","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816","og_locale":"et_EE","og_type":"article","og_title":"SQL transaktsioonid - Gleb Dranitsyn \/ Portfolio","og_description":"\u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f &#8211; \u044d\u0442\u043e \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u0445 \u0432 \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u043f\u043e\u0440\u044f\u0434\u043a\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c, \u043b\u0438\u0431\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043e\u0439, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0441 \u0411\u0414. \u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f&nbsp;\u2013 \u044d\u0442\u043e \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u0411\u0414. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u043b\u0438 \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u0451\u043c, \u0438\u0437\u043c\u0435\u043d\u044f\u0435\u043c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u044f\u0435\u043c \u0437\u0430\u043f\u0438\u0441\u044c, \u0442\u043e \u043c\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e. \u041a\u0440\u0430\u0439\u043d\u0435 \u0432\u0430\u0436\u043d\u043e \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f. \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&nbsp;ACID&nbsp;\u2013 \u0410\u0442\u043e\u043c\u0430\u0440\u043d\u043e\u0441\u0442\u044c \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e \u043b\u044e\u0431\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0431\u0443\u0434\u0435\u0442 \u0437\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u0430 \u0442\u043e\u043b\u044c\u043a\u043e \u0446\u0435\u043b\u0438\u043a\u043e\u043c (\u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e). ... Read more","og_url":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816","og_site_name":"Gleb Dranitsyn \/ Portfolio","article_modified_time":"2025-05-14T10:23:45+00:00","og_image":[{"width":521,"height":645,"url":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816","name":"SQL transaktsioonid - Gleb Dranitsyn \/ Portfolio","isPartOf":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816#primaryimage"},"image":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816#primaryimage"},"thumbnailUrl":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2.png","datePublished":"2025-05-14T07:39:01+00:00","dateModified":"2025-05-14T10:23:45+00:00","breadcrumb":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816#primaryimage","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2.png","contentUrl":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-2.png","width":521,"height":645},{"@type":"BreadcrumbList","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=816#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/glebdranitson24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"SQL transaktsioonid"}]},{"@type":"WebSite","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#website","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/","name":"Gleb Dranitsyn \/ Portfolio","description":"Tarkvara aarendaja","publisher":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/glebdranitson24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#organization","name":"Gleb Dranitsyn \/ Portfolio","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/cropped-cropped-logo1.jpg","contentUrl":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/cropped-cropped-logo1.jpg","width":400,"height":171,"caption":"Gleb Dranitsyn \/ Portfolio"},"image":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=816"}],"version-history":[{"count":13,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/816\/revisions"}],"predecessor-version":[{"id":854,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/816\/revisions\/854"}],"wp:attachment":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}