Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Lock Unlock Table

2 Posts 2 Posters 0 Views 1 Watching

V Offline
V Offline
VK Cadec

wrote on last edited by

#1

Hi - I want to lock a table,data is then inserted and selected from this table, send to an application(thru sp) and then unlock the table. I tried searching for some thing on web - unable to find it - maybe the syntax is incorrect? Thanks.
C 1 Reply Last reply

0
V VK Cadec

Hi - I want to lock a table,data is then inserted and selected from this table, send to an application(thru sp) and then unlock the table. I tried searching for some thing on web - unable to find it - maybe the syntax is incorrect? Thanks.
C Offline
C Offline
Colin Angus Mackay

wrote on last edited by

#2

Put it in a transaction.

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
1 Reply Last reply

0

Log in to reply