SQL Server connectors by thread pool 𞓜 instructions for dtsqlservertp plug-in

This plug-in mainly supports UE4 The blueprint uses thread pools for asynchronous connections and asynchronous operations SQL Server database .

This plug-in adopts the link and execution SQL All asynchronous operations , Will not be stuck in the main drawing thread , Improve operational efficiency . The blueprint will not be called back until the database returns Completed node .

1. Database connection 【 Create SQL Server 】

Input ：

Host： database IP Address

Port: Database open port

User: Database user name

Password： Database password

DBName： Specify the database name of the connection

Thread Pool Count： Number of connection threads

Output ：

Success： Returns whether the database connection is successful

Error No: Connection error return error number , Successfully returns 0

Error Msg： The connection error returns an error message

2. Operating the database 【 Execute SQL 】

Input ：

SQL: Executive SQL sentence , Support SELECT, DELETE, INSERT, UPDATE, EXEC. Basically everything SQL Statements are supported , You can operate the database directly here .

We need some SQL Mastery of grammar , You can refer to  SQL Server course (yiibai.com)

Output ：

Success： Returns whether the operation was successfully executed

Error No： Wrong number , Successfully returns 0

Error Msg:  The execution error returns an error message

Result： Returns the database result set

3. Result set decomposition

Result The returned result set is One MAP Array of , An array is equal to one line of information , The data of this row is saved in a MAP in .

You can also use the built-in function of this plug-in , Convert the output result set to JSON.