使用蓝图连接SQL Server数据库,执行SQL语句或调用存储过程,获取返回结果集。
Use blueprints to connect to the SQL Server database, execute SQL statements or call stored procedures, and obtain and return result sets.
插件可以直接执行SQL语句,SELECT,DELETE,INSERT,UPDATE,EXEC。
直接操作数据库,并返回相应结果集,并可以把结果集转换为TArray<TMap<FString,FString>>或是Json数据。
The plugin can directly execute SQL statements, SELECT, DELETE, INSERT, UPDATE, EXEC.
Directly operate the database, and return the corresponding result set, and can convert the result set into TArray<TMap<FString, FString>> or Json data.
1. Create SQL Server
创建数据库连接,配置相应数据库信息后,会在后台一直保持连接。
After creating a database connection and configuring the corresponding database information, the connection will always be maintained in the background.
2. Execute SQL
执行数据库语句,也可以调用数据库的存储过程和函数。
Execute database statements, and can also call database stored procedures and functions.