bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

Bulk Insert random insertion on the table #74

Open Mani-i4point0 opened 1 year ago

Mani-i4point0 commented 1 year ago

Hi, I using Bulk insert for in my application with an array , while inserting a record , the few of the records on the Array inserted randomly from the Array set. I am using

  1. Query Mode : Bulk Insert.
  2. Query : Editor
  3. Parameters : Editor

My requirement is , always these array of records needs to be inserted form TOP of the Table. Please refer the attached image form Node-red and the Database

image

image

image

Is there any configuration I need to do in the MS SQL Node ? Your inputs highly appreciated ?

Best regards, Mani