WCF SQL Adapter Tip – PollingStatement

Posted: October 22, 2013  |  Categories: BizTalk Uncategorized

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.


Back to Top