SQL Server Connectors By Thread Pool | DTSQLServerTP plugin instructions

This plugin mainly supports the use of thread pool asynchronous connection and asynchronous operation of SQL Server database in UE4 blueprint.

The linking and executing SQL used by this plug-in are asynchronous operations, which will not block the main painting thread and improve the running efficiency. The Completed node of the blueprint will not be called back until the database returns.

 1. Database connection 【 Create SQL Server】

‘ 

Enter:

Host: database IP address

Port: database open port

User: database username

Password: database password

DBName: Specifies the database library name of the connection

Thread Pool Count：The number of connection threads

Output:

Success: Returns whether the database connection is successful

Error No: The connection error returns the error number, and the success returns 0

Error Msg: Connection error returns error message

2. Operate the database [Execute SQL]

Enter:

SQL: SQL statement to execute, supports SELECT, DELETE, INSERT, UPDATE, EXEC. Basically all SQL statements are supported, and the database can be manipulated directly here.
Some knowledge of SQL syntax is required.

Output:

Success: Returns whether the operation was executed successfully

Error No: Error number, returns 0 successfully

Error Msg: Execution error returns error message

Result: Returns the database result set. 

3. Result set decomposition

The result set returned by Result is an array of MAP, an array is equal to the information of one row, and the data of this row is stored in a MAP.

You can also use the built-in function of this plugin to convert the output result set to JSON.