Scribd
Upload
5 views1 page

SQL Transactions and Data Queries

The document contains SQL statements to select data from a table where the date is greater than a specified value, update the values of x to 2 for records meeting the same date criteria within a transaction, select the data again to check the update, and then roll back the transaction so the update is not committed.

Uploaded by

Bozsóki István
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
5 views1 page

SQL Transactions and Data Queries

The document contains SQL statements to select data from a table where the date is greater than a specified value, update the values of x to 2 for records meeting the same date criteria within a transaction, select the data again to check the update, and then roll back the transaction so the update is not committed.

Uploaded by

Bozsóki István
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

select * from tablica where datum > 912392189

begin tran ff
update tablica set x =2 where datum > 912392189

select * from tablica where datum > 912392189

commit tran ff
rollback tran ff

You might also like