# SQL IF EXIST in a script

**URL:** <https://forum.inductiveautomation.com/t/sql-if-exist-in-a-script/10781>\
**Category:** Ignition\
**Created:** [November 12, 2015, 6:53pm UTC](https://forum.inductiveautomation.com/t/sql-if-exist-in-a-script/10781 "2015-11-12T18:53:41Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [November 12, 2015, 7:35pm UTC](https://forum.inductiveautomation.com/t/sql-if-exist-in-a-script/10781/2 "2015-11-12T19:35:39Z")

</div>

If you are using SQL Server, look into using merge.

MERGE INTO table\_name WITH (HOLDLOCK) USING table\_name ON (condition)  
WHEN MATCHED THEN UPDATE SET column1 = value1 [, column2 = value2 …]  
WHEN NOT MATCHED THEN INSERT (column1 [, column2 …]) VALUES (value1 [, value2 …])

---

_[View the full topic](https://forum.inductiveautomation.com/t/sql-if-exist-in-a-script/10781)._