I was trying to set up a quick proof of concept today and could not remember how i set up a polling statement to SELECT one record and then delete it. I have recorded it here because It took me some time to find the syntax I had used many times before.
DELETE TOP (1) FROM dbo.CustomerTest
OUTPUT deleted.*;
The DELETE statement deletes the record and the OUTPUT clause returns the affected rows.
