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.

BizTalk Server

Over 650+ customers across
30+ countries depend on BizTalk360

Learn More

Operate efficiently with enterprise-grade Azure monitoring,
tracing, remediation & governance in one platform

Learn More

Back to Top