I have stored procedure wich select(sum) data from table1 and
insert modifyed data in table2. It is important to prevent other users of the aplication to change data(insert,update,delete) into table1, while query is in progres. How can I lock records in table1 (sql server 2000)?
Thank you
insert modifyed data in table2. It is important to prevent other users of the aplication to change data(insert,update,delete) into table1, while query is in progres. How can I lock records in table1 (sql server 2000)?
Thank you