how to lock a table explicitly

[Rishu]

hello
my query is
" how to put locks on table any type of lock "

thanks in advance for solving the query

do mail me the code to put lock

at
rishuchopra@indiatimes.com

 

[tlbroadbent]

Look in SQL Books Online (BOL) for Locking Hints. In particular you want to read about TABLOCK and TABLOCKX. I recommend that you use caution. SQL Server handles locking itself. If you use locking hints inappropriately, you can seriously impact concurrency and performance.

See articles at the following links.

http://msdn.microsoft.com/library/en-us/acdata/ac_8_con_7a_1hf7.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_impt_bcp_8unm.asp

http://msdn.microsoft.com/library/en-us/acdata/ac_8_con_7a_7xde.asp

Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com