Do more with SQL Server integrations
Zapier lets you connect SQL Server with thousands of the most popular apps, so you can automate your work and have more time for what matters most—no code required.
- Free forever for core features
- 14 day trial for premium features & apps
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
Quickly automate SQL Server integrations with Zapier's templates
Query results must have a unique
idfield so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.
Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Usually something auto-incremented like
id. Must be unique. Column names that contain a space must be enclosed within brackets
Usually something like
last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.
Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like
date_createdor your autoincrement
id. Column names that contain a space must be enclosed within brackets
We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Triggered when you add a new table.Try ItTriggerScheduled
Get started for free
You can't add more hours to the day. Zapier is the next best thing.