|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
 Posted - 07/16/2012 : 09:35:31
|
begin tran
select * from tbl with (tablockx, holdlock) where 1=0
....
commit tran
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
Table lock
