Hello,

please help me in such a stiuation

I have a stored procedure that insert a new record after checking that this record does not exist....
TODO: I need to lock the row after the select statment executed on a specific row to ensure that no changes will occure between
SELECT statment and INsert statment

EX:
sp_AddRecord

@RecordExist as int = 0
SELECT @RecordExist = COUNT(*) FROM TABLE where Condition
-- TODO: I need to lock the rows ??

IF @recordExist = 0
Insert record
ELSE
print 'Record Exist'

The case that if 2 users execute the stored procedure at same time
both will get that record doesnot exist (after select statment)
and thus it will be added twice :S.

Can a select statment be a transaction, i know that transactoin occured after update/delete/insert ... but can it be from SELECT

Thanks u in advance

This question has already been answered. Start a new discussion instead.