Template Script: Locks\Locking rows or partition.sql

BEGIN TRAN
SELECT COUNT(*) FROM ttrans.trans WITH (XLOCK,ROWLOCK) WHERE DataSupplierId = 2

ROLLBACK

Description for Template Script: Locks\Locking rows or partition.sql

Todo
Site Map | Printable View | © 2008 - 2012 NuRoN Consulting, INC | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund
Share This Using Popular Bookmarking Services