# Send Dynamic Numeric Value(Recieve from PLC) to MSSQL

**URL:** https://discourse.nodered.org/t/send-dynamic-numeric-value-recieve-from-plc-to-mssql/15427
**Category:** General
**Created:** [11 September 2019 15:08 UTC](https://discourse.nodered.org/t/send-dynamic-numeric-value-recieve-from-plc-to-mssql/15427 "2019-09-11T15:08:03Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [11 September 2019 15:35 UTC](https://discourse.nodered.org/t/send-dynamic-numeric-value-recieve-from-plc-to-mssql/15427/4 "2019-09-11T15:35:12Z")

</div>

If you are using the latest version of MSSQL-plus node it has several examples in the built in help (I know, I wrote them).

Here is an example...

```auto
INSERT INTO [Dev].[dbo].[MQTTData]
 (Topic,Payload) 
VALUES ('{{topic}}',{{payload}})

```

---

_[View the full topic](https://discourse.nodered.org/t/send-dynamic-numeric-value-recieve-from-plc-to-mssql/15427)._
