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 500+ customers across
30+ countries depend on BizTalk360

Learn More

Manage and monitor serverless
components effortlessly

Learn More
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top