RE: Returning updated rows

2004-06-19 Thread Matt Chatterley
nhaeuser [mailto:[EMAIL PROTECTED] > Sent: 19 June 2004 23:40 > To: [EMAIL PROTECTED] > Subject: Returning updated rows > > Is it possible that one can return the actual rows, which where > affected by an update statement? > > What I want to do: I have n rows in a table which s

Returning updated rows

2004-06-19 Thread Thomas Schwanhaeuser
Is it possible that one can return the actual rows, which where affected by an update statement? What I want to do: I have n rows in a table which symbolize some work, which have several servers to do. For this, the table has a column called INPROCESS. In order that multiple servers can work