title: Column-level locking in SQL Server 2008
body: <p>In SQL Server I have a table with 10 columns, I want to update a particular column value in the table, &amp; I want to put lock before updating by which others cannot update the table at same time. ex- i have two column names are id1 &amp; id2, at any time only one column will be updated, so i want to put a lock only on that column, reamin column should be free for other user can update it.</p>