lockinging a table

[tek1ket]

how can i lock a table when inserting a record in it?

 

[sqlfable]

The engine already will put an exclusive lock on the table unless you otherwise use hints to prevent such normal engine operations

You seem to need a bunch of reading time

Try starting here

http://www.mssqlcity.com/Articles/General/sql2000_locking.htm

 

[markros]

If you want to simulate a record lock in SQL Server you can try this technique described by Sergey Berezniker at another forum:

-- Will hold a lock on a record until COMMIT is issued. Exec 1 line at a time in SMSS


BEGIN TRANSACTION

SELECT SomeColumn FROM dbo.MyTable WITH (TABLOCKX) WHERE SomeCriteria

(Now run application code against locked record)

COMMIT  -- Releases lock