![\"\"](\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2018\/03\/sql_transact_1.png\"){kind=spacer}
<\/a><\/p>\nWrite a query that will change the name in the directory row in the SQL window: convert ii from uppercase to lowercase and vice versa.<\/span> [code] SET AName = Upper(AName)<\/p>\n WHERE ID = 1<\/p>\n UPDATE Applications<\/p>\n SET AName = LOWER(AName)<\/p>\n WHERE ID = 1 Put this query in a transaction.<\/p>\n [code] \tUPDATE Applications UPDATE Applications COMMIT TRANSACTION<\/p>\n [\/code]<\/p>\n Check the transactions available at the server using the system view sys.dm_tran_active_transactions in a new SQL window.<\/span> [code]SELECT * FROM sys.dm_tran_active_transactions[\/code]<\/p>\n Check the lock resources available on the server using the system view sys.dm_tran_locks in a new SQL window.<\/p>\n [code]SELECT * FROM sys.dm_tran_locks [\/code]<\/p>\n Run the transaction opening, update, and display the table with SELECT statement, without a transaction completion. Make sure the update is reflected for the transaction.<\/p>\n [code] UPDATE Applications UPDATE Applications SELECT * FROM Applications [code] SELECT * FROM Applications<\/p>\n SELECT * FROM Applications WITH (NOLOCK)<\/p>\n SELECT * FROM Applications WHERE ID = 2<\/p>\n SELECT * FROM Applications WHERE AName = ‘Photoshop’<\/p>\n [\/code]<\/p>\n <\/p>\n Check the transactions available at the server using the system view sys.dm_tran_active_transactions in the SQL window. You should see a new user transaction<\/span>.<\/span><\/p>\n Check the locks on resources available on the server using system view sys.dm_tran_locks in the SQL window. The lock associated with active table should be added. Determine which resource is locked.<\/span> [code] Roll back the transaction in the window \u2014 use only the ROLLBACK statement. The output of the table using SELECT statement should show the difference with the upgrade.<\/p>\n [code] UPDATE Applications UPDATE Applications ROLLBACK TRANSACTION <\/p>\n SELECT * FROM Applications After re-output of the view, a user transaction in the SQL window should disappear.<\/p>\n [code]SELECT * FROM sys.dm_tran_active_transactions [\/code]<\/p>\n After re-output of the view, a lock connected with the current table in the SQL window should disappear.<\/span><\/p>\n [code] The contents of the table involved with the canceled update should finally appear in the SQL window.<\/span><\/p>\n Thanks for your attention!<\/span><\/p>\n <\/p>\n One of our experts has completed a task related to <\/span><\/i>SQL transaction<\/i> in order to help you to improve your skills in SQL. If you need help with your homework, AssignmentShark provides SQL homework help <\/a><\/span><\/i>and assistance with case studies. Our service delivers solutions that serve as an educational basis for students who have problems with completing their assignments on MySQL. Our experts will provide prompt help with any kind of homework strictly in accordance with your requirements. We don\u2019t store completed homework and don\u2019t resell to other students. Each homework assignment is completed individually for each student by the expert in the particular discipline.<\/span><\/i><\/p>\n We know that IT is a complex area of knowledge, so we have gathered professionals that can help you in various fields of database optimization, data analysis, QA and software texting, etc. As for our rates, we consider them affordable for students. Our bidding system allows you to pick an expert with the most suitable parameters concerning experience, rating, number of completed works, and the price for your particular assignment. You will have the opportunity to control the work progress and stay in touch with the expert using the online chat. All payments are conducted only for completed parts of your order, so you don\u2019t need to pay for a pig in a poke. Got stuck with homework? Take the opportunity to reduce stress from studying and get online assignment help<\/a> right now!<\/span><\/i><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":" Transactions in SQL In the process of this exercise, we observe how a given type of the table lock level interacts with the blocking that sets out the transaction at the query. Select the table that contains the dictionary with the column names.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53,35],"tags":[],"class_list":["post-8452","post","type-post","status-publish","format-standard","hentry","category-it","category-samples"],"_links":{"self":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/8452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/comments?post=8452"}],"version-history":[{"count":11,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/8452\/revisions"}],"predecessor-version":[{"id":13147,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/8452\/revisions\/13147"}],"wp:attachment":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/media?parent=8452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/categories?post=8452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/tags?post=8452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<\/span><\/p>\n
\nUPDATE Applications<\/p>\n
\n[\/code]<\/p>\n<\/a><\/p>\n
\nBEGIN TRANSACTION<\/p>\n
\nSET AName = Upper(AName)
\nWHERE ID = 1<\/p>\n
\nSET AName = LOWER(AName)
\nWHERE ID = 1<\/p>\n
\n<\/span><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
\nBEGIN TRANSACTION<\/p>\n
\nSET AName = Upper(AName)
\nWHERE ID = 1<\/p>\n
\nSET AName = LOWER(AName)
\nWHERE ID = 1<\/p>\n
\n[\/code]<\/p>\n<\/a><\/p>\n\n
\nBEGIN TRANSACTION
\nINSERT INTO Applications (ID, AName, AVersion) VALUES (4, ‘Photoshop’, 2015)
\n\t\tWAITFOR DELAY ’00:01′
\nROLLBACK<\/p>\n<\/a><\/p>\n<\/a><\/p>\n
\n<\/span><\/p>\n
\nSELECT b.name, c.name, a.*
\nFROM sys.dm_tran_locks a
\nINNER JOIN sys.databases b ON a.resource_database_id = database_id
\nINNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id
\n[\/code]<\/p>\n<\/a><\/p>\n
\nBEGIN TRANSACTION<\/p>\n
\nSET AName = Upper(AName)
\nWHERE ID = 3<\/p>\n
\nSET AName = LOWER(AName)
\nWHERE ID = 3<\/p>\n
\n[\/code]<\/p>\n<\/a><\/p>\n
\nSELECT b.name, c.name, a.*
\nFROM sys.dm_tran_locks a
\nINNER JOIN sys.databases b ON a.resource_database_id = database_id
\nINNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id
\n[\/code]<\/p>\n<\/a><\/p>\n<\/a><\/p>\nNeed MySQL Homework Help?<\/span><\/i><\/h2>\n