# Sending multiple modbus data values to SQL Server (Azure) in one stored procedure

**URL:** https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488
**Category:** General
**Created:** [21 July 2020 15:39 UTC](https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488 "2020-07-21T15:39:59Z")
**Posts on this page:** 5
**Page:** 2

<div class="post-metadata">

### Author: ![ermanish533](https://avatars.discourse-cdn.com/v4/letter/e/a88e57/32.png) [@ermanish533](https://discourse.nodered.org/u/ermanish533)
#### Post date: [12 August 2020 11:57 UTC](https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488/21 "2020-08-12T11:57:20Z")

</div>

HI,

I have been running this code since last two weeks and it is perfectly working fine.

Thanks for all your support!!!!!

---

<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: [12 August 2020 11:58 UTC](https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488/22 "2020-08-12T11:58:29Z")

</div>

That's great news.

Can I ask, are you using both stored procedures and queries?

And lastly, at a guess, how many operations do you think it may have done?

Thanks for the feedback.

---

<div class="post-metadata">

### Author: ![Energycharges](https://avatars.discourse-cdn.com/v4/letter/e/e47c2d/32.png) [@Energycharges](https://discourse.nodered.org/u/Energycharges)
#### Post date: [25 August 2020 20:33 UTC](https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488/23 "2020-08-25T20:33:26Z")

</div>

hi Steve,

how to include timestamp to the queries values and store in mysql DB on real time

thanks

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [25 August 2020 20:52 UTC](https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488/24 "2020-08-25T20:52:18Z")

</div>

> [@Energycharges](#):
>
> store in mysql DB

Welcome to the forum @Energycharges.  
You may not have noticed, but this thread is about MSSQL, not MySQL. I suggest you start a new thread for the question (however, before you do that, note that it is possible to define a timestamp field in mysql that defaults to the current time so if that is what you want then you don't actually need to worry about the timestamp at all).

---

<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: [19 September 2020 15:40 UTC](https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488/25 "2020-09-19T15:40:07Z")

</div>

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

[Previous page](https://discourse.nodered.org/t/sending-multiple-modbus-data-values-to-sql-server-azure-in-one-stored-procedure/30488.md?page=1)