A web site to change add records remove etc
- website isn't connected architecture, and so i cant expect sql to refuse creates to some table being edit by someone else also. As information is only written when its delivered back to server through the power grid..
so it is possible to way using c# and asp.internet, some code , through which i cant clearly tell the sql server to lock the table, to ensure that viewing is permitted but conntacting it gives error like
"sorry another user is applying the writting function with this table please wait".
No. SQL doesn't support "lock nowait" semantics with normal transaction modes only Oracle does. See http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg08sql.htm#5732 for additional info on Oracle. Yes, the code will just hang before the table is launched.
There's a choice of cutting your transaction mode, however you receive a lot more like "free for thoseInch semantics, that you simply most likely also do not want.