Microsoft SQL Server on-premises - Create a SQL record

Use the Microsoft SQL Server on-premises - Create a SQL record action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to insert a new row in a SQL table.

This adds new data to the SQL table.

For more information about the Microsoft SQL Server on-premises connector, go to Microsoft SQL Server on-premises.

Before you begin: 

Jump to:

Configure the Microsoft SQL Server on-premises - Create a SQL record action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  2. Select a Connection. If you do not have a connection, see Add a connection.
  1. Select the SQL Table.
  2. Specify the values of any required fields.
  3. Click the Add field button to add non-required record fields.

  4. Select the fields. Click Add.

  5. Specify the value of the added fields.

Microsoft SQL Server on-premises - Create a SQL record action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Microsoft SQL Server on-premises connection to use to create the new record.

To refresh the available connections, click .

(n/a)
Table

The SQL table you want to create a new record in.

 Text, Decimal, Integer, Boolean, DateTime, Collection
  Add fields

Required column fields automatically display. Use the Add fields button to add any non-required fields that you need to specify a value for when creating the new record.

The value type of each field is based on the column type in the SQL table. Numerical precision, scale, date type, and maximum values are shown in the field sub-text.

Read-only column fields, like Identity, Calculated, or Timestamp, cannot be specified while creating a new record, and those field types are not available in this action.

SQL Data type Nintex variable type Notes
bit Boolean  
decimal Decimal  
money Decimal  
numeric Decimal  
smallmoney Decimal  
float Decimal  
real Decimal  
binary File Not supported.
image File Not supported.
varbinary File Not supported.
bigint Integer Limited support, see the known issues list.
int Integer  
smallint Integer  
tinyint Integer  
rowversion Integer  
cursor N/A Not supported.
hierarchyid N/A Not supported.
sql_variant N/A Not supported.
Spatial Geometry Types N/A Not supported.
table N/A Not supported.
uniqueidentifier String  
xml String  
char Text  
text Text  
varchar Text  
nchar Text  
ntext Text  
nvarchar Text  
datetimeoffset Text  
time Text  
rowversion Text  
timestamp Text  
date DateTime  
datetime DateTime  
datetime2 DateTime  
smalldatetime DateTime  
The variable type is dependent on the column type in the SQL table.
Output Item

Stores the result of the action as an object. See Microsoft SQL Server on-premises Create for more details. The following values are returned:

  • Is full result set: (Boolean) Returns False if a data type was excluded, like read-only columns.
  • Result Set: (Object)
    • List of record fields
 Object