Search notes:

SQL Server: transactions

go

go has no effect on transactions.

TODO

set transaction isolation level
begin transaction -> @@trancount ++
commit -> @@trancount --
rollback -> @@transcount = 0
@@transcount = 1 -> changes are written to database.
Some of the stuff of this page probable belongs to SQL Server SQL: transactions.

See also

The function xact_state() can be used to determine if a session (?) has an active transaction.
@@trancount counts the nesting level of transactions.
transaction log
The transactional data that is needed to recover a database is stored in log files.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740453447, '18.221.139.125', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/SQL-Server/architecture/transaction/index(68): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78