single access on store procedure
-
Hello, Is their a Critical section function on store procedure? Or what is the counter part of CriticalSection of C in store procedure script?
What are you trying to do? You can lock tables, etc... yourself if you want, but that could slow your whole architecture down. Cheers, Simon "I ask candidates to create an object model of a chicken.", Bruce Eckel on interviewing programmers. animation mechanics in SVG (latest pic 1) (latest pic 2)
-
What are you trying to do? You can lock tables, etc... yourself if you want, but that could slow your whole architecture down. Cheers, Simon "I ask candidates to create an object model of a chicken.", Bruce Eckel on interviewing programmers. animation mechanics in SVG (latest pic 1) (latest pic 2)
Yeah, you should by default allow SQL to handle locking. If you concern is that all processes should complete or fail look at BEGIN TRANSACTION ROLLBACK TRANSACTION COMMIT TRANSACTION
