Sql
-
hy, how can i create a transaction so that when ever i update a row of a table no other user can change it or access it.. its like transaction on a account , only one user can operate on an account at a time. i tried the following sql statement LOCK [ TABLE ] name IN lock_mode but it gives an error "incorrect syntax near table" should i create a stored procedure and then use SET TRANSACTION ISOLATION LEVEL SERIALATION after creating a transaction. plz help
-
hy, how can i create a transaction so that when ever i update a row of a table no other user can change it or access it.. its like transaction on a account , only one user can operate on an account at a time. i tried the following sql statement LOCK [ TABLE ] name IN lock_mode but it gives an error "incorrect syntax near table" should i create a stored procedure and then use SET TRANSACTION ISOLATION LEVEL SERIALATION after creating a transaction. plz help
-
What is your problem? This is the 3rd time you have asked the question, the answer is NOT going to change!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! http://www.codeproject.com/script/Forums/View.aspx?fid=12076[^]
Bob Ashfield Consultants Ltd
Ashfield wrote:
This is the 3rd time you have asked the question, the answer is NOT going to change!!!!!
:laugh::laugh::laugh:
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham