Microsoft SQL Server on-premises - Update SQL records

Use the Microsoft SQL Server on-premises - Update SQL records action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to update data in specific rows of a 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 - Update SQL records 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 fields.
  6. Click Add condition to define which records to update.

Microsoft SQL Server on-premises - Update SQL records 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 update the records.

To refresh the available connections, click .

(n/a)
Table

The SQL table you want to update records 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 updating the new record.

The field type 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.
  Add condition

Click Add condition to define which records to update. This builds a SQL WHERE statement defining what records to update.

When: The column selected for the condition.

Operator: The operator type of the conditional case statement, such as equals, does not equal, is empty, is not empty, contains, begins with, or ends with.

Value: The specific value searched for.

Summary: A short description of your condition.

For example, WHEN LastName equals Smith would update all the records in that table where Smith is the value of the LastName column.

 Text, Decimal, Integer, Boolean, DateTime, Collection
Output Records affected

Stores the number of SQL records updated.

 Integer