# Insert new record into MSSQL

**URL:** <https://discourse.nodered.org/t/insert-new-record-into-mssql/73823>\
**Category:** General\
**Created:** [17 January 2023 17:53 UTC](https://discourse.nodered.org/t/insert-new-record-into-mssql/73823 "2023-01-17T17:53:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [17 January 2023 18:32 UTC](https://discourse.nodered.org/t/insert-new-record-into-mssql/73823/2 "2023-01-17T18:32:23Z")

</div>

> [@dpenz](#):
>
> and what should the INSERT statement look like

It should look exactly like you want it.

Example..

```sql
INSERT INTO test_data.settings 
( [test_run#], [pump_type], [etc] ) 
VALUES ( 
  @param1, 
  @param2, 
  @param3
)

```

where @param1 ~ @param3 are entered in the "parameters" section & mapped to the correct property in the `msg` and set for the intended type.

Here is a couple of threads that explain how:

- [Logging data in to MSSQL - #13 by Steve-Mcl](https://discourse.nodered.org/t/logging-data-in-to-mssql/67539/13)
- [SQL data return array data types? MSSQL Node - #3 by Steve-Mcl](https://discourse.nodered.org/t/sql-data-return-array-data-types-mssql-node/72157/3)
- [and more](https://discourse.nodered.org/search?q=%40Steve-Mcl%20mssql%20parameters%20order%3Alatest)

---

_[View the full topic](https://discourse.nodered.org/t/insert-new-record-into-mssql/73823)._