Click here to Skip to main content
15,891,943 members

Comments by Brian Holsen (Top 6 by date)

Brian Holsen 11-Jan-15 22:17pm View    
@cur is the name of cursor, @status is nvarchar(20)
Brian Holsen 5-Jan-15 23:35pm View    
I don't know what's table1 doing here, and if deleted table holds more than one record, it won't work.
Brian Holsen 5-Jan-15 23:29pm View    
I used "improve question" and actually deleted some of my descriptions
that is just a simple example up there, sometimes maybe not just as simple as logging data, maybe I need to parse some data of each deleted records to a procedure to do some complex operations.
I just want to know if there is always a way to handle all kinds of situations without using cursor.
Brian Holsen 5-Jan-15 23:22pm View    
IF @status!='normal'
what's wrong with it?
Brian Holsen 26-Aug-13 7:16am View    
I don't quite understand.
Do you mean that, if P1 is changed, P2 will be changed, and also, P2->P3, P3->P4, but not in the inverse order?