# How to check duplicate data and not insert to sql

**URL:** <https://discourse.nodered.org/t/how-to-check-duplicate-data-and-not-insert-to-sql/75768>\
**Category:** General\
**Tags:** node-red-dashboard, database\
**Created:** [26 February 2023 16:41 UTC](https://discourse.nodered.org/t/how-to-check-duplicate-data-and-not-insert-to-sql/75768 "2023-02-26T16:41:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [26 February 2023 16:41 UTC](https://discourse.nodered.org/t/how-to-check-duplicate-data-and-not-insert-to-sql/75768/1 "2023-02-26T16:41:36Z")

</div>

```auto
var value = 6

var pld

pld = "INSERT INTO [HIG].[dbo].[Alum]"

pld = pld + "([Aluminium])"

pld = pld + "VALUES ('" + value + "')"

msg.payload = pld

return msg;

```

IF value equals 6 not insert data to sql

**\> ?? How to check ??**

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [26 February 2023 16:49 UTC](https://discourse.nodered.org/t/how-to-check-duplicate-data-and-not-insert-to-sql/75768/2 "2023-02-26T16:49:23Z")

</div>

I don't understand, you are setting 'value' to six.

Are you trying to see if the msg entering your function has a value of 6? If so, add a switch node before the function node to test for 6 and don't pass the msg if it does.

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [26 February 2023 16:57 UTC](https://discourse.nodered.org/t/how-to-check-duplicate-data-and-not-insert-to-sql/75768/3 "2023-02-26T16:57:19Z")

</div>

Or do you want to only INSERT if a record already exists WHERE value = 6 ?

If so, what dbms are you using?

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [26 February 2023 17:04 UTC](https://discourse.nodered.org/t/how-to-check-duplicate-data-and-not-insert-to-sql/75768/4 "2023-02-26T17:04:38Z")

</div>

sql server management studio  
if data is duplicate not insert

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [27 April 2023 17:05 UTC](https://discourse.nodered.org/t/how-to-check-duplicate-data-and-not-insert-to-sql/75768/5 "2023-04-27T17:05:02Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.