Click here to Skip to main content
15,909,546 members

Comments by vins555 (Top 17 by date)

vins555 9-Mar-12 1:07am View    
i made an sp that works delete both parent and child records i want but now the problem is testing the sp as i m unable to lock records lets consider a scenario in which record from parent contains three records in child now if i lock one of the recorfd then the delete transaction shud b rollback so in this case how to lock one of the row from child record please help me for that.
vins555 9-Mar-12 1:07am View    
i made an sp that works delete both parent and child records i want but now the problem is testing the sp as i m unable to lock records lets consider a scenario in which record from parent contains three records in child now if i lock one of the recorfd then the delete transaction shud b rollback so in this case how to lock one of the row from child record please help me for that.
vins555 9-Mar-12 1:06am View    
i made an sp that works delete both parent and child records i want but now the problem is testing the sp as i m unable to lock records lets consider a scenario in which record from parent contains three records in child now if i lock one of the recorfd then the delete transaction shud b rollback so in this case how to lock one of the row from child record please help me for that.
vins555 9-Mar-12 0:29am View    
is it possible with stored procedure???
vins555 8-Mar-12 23:31pm View    
okay thanks i wl try that.