Script Development / Microsoft SQL Server

Microsoft SQL Server connector action objects primarily provide methods for operating Microsoft SQL Server.

DFF.CONN(...) parameters are as follows:

Parameter	Type	Required / Default Value	Description
`connector_id`	str	Required	Connector ID
`database`	str	`None`	Specified database

`.query(...)`

Executes an SQL statement, with the following parameters:

Parameter	Type	Required / Default Value	Description
`sql`	str	Required	SQL statement, may include parameter placeholders. `?` indicates a parameter that needs escaping; `??` indicates a parameter that does not need escaping.
`sql_params`	list	`None`	SQL parameters

Example
sql = 'SELECT * FROM ?? WHERE seq > ?'
sql_params = ['demo', 1]
result = db.query(sql, sql_params=sql_params)

Dynamic SQL Statement

query(...) and non_query(...) internally use DFF.SQL(...) to construct SQL statements and support building complex dynamic SQL statements.

For example, when there is an uncertain number of values in WHERE IN (...), or when performing bulk data insertion using INSERT INTO ... VALUES ....

For more details, please refer to Script Development / SQL Construction DFF.SQL