![](https://csdnimg.cn/release/download_crawler_static/87928359/bg10.jpg)
Contents
xvi
Adaptive Server
Transaction modes and stored procedures........................... 655
Using cursors in transactions ....................................................... 657
Issues to consider when using transactions................................. 658
Backup and recovery of transactions ........................................... 659
CHAPTER 19 Locking Commands and Options .............................................. 661
Setting a time limit on waiting for locks ........................................ 661
wait/nowait option of the lock table command....................... 662
Setting a session-level lock-wait limit.................................... 663
Setting a server-wide lock-wait limit ...................................... 664
Information on the number of lock-wait timeouts................... 664
Readpast locking for queue processing ....................................... 665
Readpast syntax.................................................................... 665
Incompatible locks during readpast queries.......................... 665
Allpages-locked tables and readpast queries........................ 666
Effects of isolation levels select queries with readpast ......... 666
Data modification commands with readpast and isolation levels .
667
text and image columns and readpast .................................. 668
Readpast-locking examples .................................................. 668
APPENDIX A The pubs2 Database.................................................................... 671
Tables in the pubs2 database ...................................................... 671
publishers table ..................................................................... 671
authors table.......................................................................... 672
titles table .............................................................................. 674
titleauthor table...................................................................... 681
salesdetail table..................................................................... 683
sales table ............................................................................. 688
stores table............................................................................ 689
roysched table....................................................................... 690
discounts table ...................................................................... 694
blurbs table............................................................................ 695
au_pix table........................................................................... 696
Diagram of the pubs2 database ................................................... 699
APPENDIX B The pubs3 Database.................................................................... 701
Tables in the pubs3 database ...................................................... 701
publishers table ..................................................................... 701
authors table.......................................................................... 702
titles table .............................................................................. 704
titleauthor table...................................................................... 711