var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Locking a table
Can any one please tell me how to lock & unlock a table a from inside a store procedure using T-SQL
That's best left to the optimizer....
I am not sure. Some one in my devlopment team asked me that.
I have done using DAO from VB front end. But not thru stored procedure
Just think of it this way...as a way to approach working with the database...
Keep all transactions as short as possible...
If someone is interested in locking a table, then that aint short...
Don't leave open record sets...
Get in, get the data, save it to an array and get out..
sprocs are the way to go...
My Own opinion
I guess their main concern is in that fraction of minutes if some one pulls the record for update while this procedure is being executed.
and that is why there should be an update_ts column...
such that the process should check to see if the record was updated before you overlay with your update...
You should tell the user that the data has changed since last accessed....
And show them what he change was.....