当前位置:网站首页>SQL Server Connectors By Thread Pool | DTSQLServerTP plugin instructions
SQL Server Connectors By Thread Pool | DTSQLServerTP plugin instructions
2022-04-23 20:14:00 【阿六_Dexter】
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.
版权声明
本文为[阿六_Dexter]所创,转载请带上原文链接,感谢
https://blog.csdn.net/wmy19890322/article/details/124324864
边栏推荐
- Introduction to electron Tutorial 4 - switching application topics
- Scrum Patterns之理解各种团队模式
- 【数值预测案例】(3) LSTM 时间序列电量预测,附Tensorflow完整代码
- Design of library management database system
- 微信中金财富高端专区安全吗,证券如何开户呢
- Comment créer un pass BEP - 20 sur la chaîne BNB
- R语言survival包coxph函数构建cox回归模型、ggrisk包ggrisk函数和two_scatter函数可视化Cox回归的风险评分图、解读风险评分图、基于LIRI数据集(基因数据集)
- Possible root causes include a too low setting for -Xss and illegal cyclic inheritance dependencies
- STM32基础知识
- Shanda Wangan shooting range experimental platform project - personal record (V)
猜你喜欢
Kubernetes introduction to mastery - ktconnect (full name: kubernetes toolkit connect) is a small tool based on kubernetes environment to improve the efficiency of local test joint debugging.
Error reported by Azkaban: Azkaban jobExecutor. utils. process. ProcessFailureException: Process exited with code 127
波场DAO新物种下场,USDD如何破局稳定币市场?
Sqoop imports tinyint type fields to boolean type
selenium. common. exceptions. WebDriverException: Message: ‘chromedriver‘ executable needs to be in PAT
Shanda Wangan shooting range experimental platform project - personal record (IV)
AQS learning
STM32 Basics
WordPress plug-in: WP CHINA Yes solution to slow domestic access to the official website
Kubernetes entry to mastery - bare metal loadbalance 80 443 port exposure precautions
随机推荐
Openharmony open source developer growth plan, looking for new open source forces that change the world!
C6748 software simulation and hardware test - with detailed FFT hardware measurement time
PCL点云处理之直线与平面的交点计算(五十三)
How to create bep-20 pass on BNB chain
Comment créer un pass BEP - 20 sur la chaîne BNB
R语言使用econocharts包创建微观经济或宏观经济图、indifference函数可视化无差异曲线、自定义计算交叉点、自定义配置indifference函数的参数丰富可视化效果
Esp8266 - beginner level Chapter 1
MySQL 进阶 锁 -- MySQL锁概述、MySQL锁的分类:全局锁(数据备份)、表级锁(表共享读锁、表独占写锁、元数据锁、意向锁)、行级锁(行锁、间隙锁、临键锁)
Remote code execution in Win 11 using wpad / PAC and JScript 3
考研英语唐叔的语法课笔记
SRS 的部署
R language survival package coxph function to build Cox regression model, ggrisk package ggrisk function and two_ Scatter function visualizes the risk score map of Cox regression, interprets the risk
SIGIR'22「微软」CTR估计:利用上下文信息促进特征表征学习
R language ggplot2 visualization: ggplot2 visualizes the scatter diagram and uses geom_ mark_ The ellipse function adds ellipses around data points of data clusters or data groups for annotation
Understanding various team patterns in scrum patterns
Mysql database and table building: the difference between utf8 and utf8mb4
DTMF双音多频信号仿真演示系统
The R language uses the timeroc package to calculate the multi time AUC value of survival data without competitive risk, and uses the confint function to calculate the confidence interval value of mul
Project training of Software College of Shandong University - Innovation Training - network security shooting range experimental platform (6)
論文寫作 19: 會議論文與期刊論文的區別