Script Development / Microsoft SQL Server

The Microsoft SQL Server connector operation object primarily provides methods for operating on 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. `?` represents an escaped parameter; `??` represents a non-escaped parameter
`sql_params`	list	`None`	SQL parameters

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

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

For example, when dealing with an uncertain number of values in WHERE IN (...), or performing bulk data inserts using INSERT INTO ... VALUES ....