(license MIT) library for work with Microsoft SQL Server, full example - see example.js
\ntype_exec_table_resultArray.<number>functionfunctionfunctionfunctionfunctionfunctionfunctionfunctionfunctionfunctionfunctionfunctionfunctionboolean\n * [.timezone_offset](#Server_mssql+timezone_offset) : number\n * [.init(connection_config, callback)](#Server_mssql+init)\n * [.exec(queries, [options], callback)](#Server_mssql+exec)\n * [~exec_result](#Server_mssql+exec..exec_result)\n * [.action_add(action)](#Server_mssql+action_add) ⇒ string\n * [.action_del(key)](#Server_mssql+action_del)\n * [.action_check(key)](#Server_mssql+action_check) ⇒ [type\\_action\\_find](#type_action_find)\n * [.action_exec(key, params, callback)](#Server_mssql+action_exec)\n * [.schedule_go(job)](#Server_mssql+schedule_go)\n * [.schedule_delete(job_key)](#Server_mssql+schedule_delete)\n * [.get_newid(callback)](#Server_mssql+get_newid)\n * [.date_in_sql([d])](#Server_mssql+date_in_sql) ⇒ Date\n\n\n\n### server_mssql.connected : boolean\n**Kind**: instance property of [Server\\_mssql](#Server_mssql) \n\n\n### server_mssql.timezone\\_offset : number\n**Kind**: instance property of [Server\\_mssql](#Server_mssql) \n\n\n### server_mssql.init(connection_config, callback)\ninit library, check connect to MS SQL Server\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type | Description |\n| --- | --- | --- |\n| connection_config | [type\\_connection\\_config](#type_connection_config) | connection setting |\n| callback | [callback\\_error](#callback_error) | |\n\n\n\n### server_mssql.exec(queries, [options], callback)\nexec query or queries\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type | Description |\n| --- | --- | --- |\n| queries | string \\| Array.<string> | query or array of queries (for run on one open connection) |\n| [options] | [type\\_exec\\_option](#type_exec_option) | |\n| callback | [callback\\_exec](#callback_exec) | |\n\n\n\n#### exec~exec\\_result\n**Kind**: inner property of [exec](#Server_mssql+exec) \n**Privare**: @type {type_exec_result} \n\n\n### server_mssql.action\\_add(action) ⇒ string\nadd one action\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n**Returns**: string - error that prevented load action \n\n| Param | Type | Description |\n| --- | --- | --- |\n| action | [type\\_action](#type_action) | single action |\n\n\n\n### server_mssql.action\\_del(key)\ndelete action from list\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type | Description |\n| --- | --- | --- |\n| key | string | action key |\n\n\n\n### server_mssql.action\\_check(key) ⇒ [type\\_action\\_find](#type_action_find)\nfind action key and load errors\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type | Description |\n| --- | --- | --- |\n| key | string | action key |\n\n\n\n### server_mssql.action\\_exec(key, params, callback)\nexec action\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type | Description |\n| --- | --- | --- |\n| key | string | uniq key of action |\n| params | any | |\n| callback | [callback\\_action](#callback_action) | |\n\n\n\n### server_mssql.schedule\\_go(job)\nadd new schedule or replace existsing schedule\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type |\n| --- | --- |\n| job | lib\\_vschedule.type\\_job | \n\n\n\n### server_mssql.schedule\\_delete(job_key)\nremove existsing schedule\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type |\n| --- | --- |\n| job_key | string | \n\n\n\n### server_mssql.get\\_newid(callback)\nget new guid\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type | Description |\n| --- | --- | --- |\n| callback | [callback\\_get\\_newid](#callback_get_newid) | error, guid |\n\n\n\n### server_mssql.date\\_in\\_sql([d]) ⇒ Date\nget date in ms sql server\n\n**Kind**: instance method of [Server\\_mssql](#Server_mssql) \n\n| Param | Type | Description |\n| --- | --- | --- |\n| [d] | Date | local date regarding which to get the date on the server, default - now |\n\n\n\n## clone\\_table(from) ⇒ [type\\_exec\\_table\\_result](#type_exec_table_result)\n**Kind**: global function \n\n| Param | Type |\n| --- | --- |\n| from | [type\\_exec\\_table\\_result](#type_exec_table_result) | \n\n\n\n## noname\\_row\\_beautify(table, type_ext)\n**Kind**: global function \n\n| Param | Type |\n| --- | --- |\n| table | [type\\_exec\\_table\\_result](#type_exec_table_result) | \n| type_ext | boolean | \n\n\n\n## find\\_disappeared\\_numbers(nums) ⇒ Array.<number>\n**Kind**: global function \n\n| Param | Type |\n| --- | --- |\n| nums | Array.<number> | \n\n\n\n## type\\_connection\\_config\n**Kind**: global typedef \n**Properties**\n\n| Name | Type | Description |\n| --- | --- | --- |\n| server | string | MS SQL instance, for example - 'server\\\\instance1' |\n| password | string | passrord for ms sql authentication or windows authentication |\n| [login] | string | login for ms sql authentication, if empty - os authentication |\n| database | string | name database for connect, default - 'tempdb' |\n| [app_name] | string | app name, which will be visible in profiler |\n| [connection_timeout] | number | connection timeout in milliseconds, default - 15000 |\n| [execution_timeout] | number | execution timeout in milliseconds, default - 0 (infinity) |\n| [encrypt_connection] | boolean | encrypt connection, default - false |\n| [useUTC] | boolean | default - true |\n| [action_allow] | boolean | use action subsystem, default - false |\n| [again_connect_count] | number | count to try to connect to the server if the connection is unavailable, default - 0 (again try connect is disabled) |\n| [again_connect_timeout] | number | timeout in milliseconds between attempts to connect to the server, default - 2000 |\n\n\n\n## type\\_action\n**Kind**: global typedef \n**Properties**\n\n| Name | Type | Description |\n| --- | --- | --- |\n| key | string | action uniq key |\n| sql_script | string | |\n| [sql_param] | string | |\n| [sql_param_note] | string | |\n| [sql_result] | string | |\n| [sql_lock] | string | one thread - name |\n| [sql_lock_wait] | number | one thread - wait timeout in milliseconds (0 - no wait), default 0 |\n| [sql_lock_message] | string | one thread - message if lock exists |\n| [js_script] | string | |\n| title | string | action title |\n| [note] | string | action title |\n| [keys_next] | string | exec this actions after exec this action, example - 'key1;key2' |\n| [correction_utc_mode] | string | |\n| [extented_property] | Object | |\n\n\n\n## type\\_generate\\_class\\_with\\_exec\\_actions\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| [action_class_template] | string | \n| [class_name] | string | \n\n\n\n## callback\\_empty : function\n**Kind**: global typedef \n\n\n## callback\\_error : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| error | Error | \n\n\n\n## type\\_exec\\_option\n**Kind**: global typedef \n**Properties**\n\n| Name | Type | Description |\n| --- | --- | --- |\n| [correction_utc] | [type\\_exec\\_correction\\_utc\\_option](#type_exec_correction_utc_option) | |\n| [lock] | [type\\_exec\\_lock\\_option](#type_exec_lock_option) | one thread subsystem |\n| [noname_row_beautify] | boolean | default - false |\n| [chunk_rows] | number | return result by chunk, default - off (undefined) |\n| [chunk_msec] | number | return result by chunk, default - off (undefined) |\n| [check_database_after_exec] | boolean | return database name, which is active at the time the script is finished, default - false |\n| [check_spid] | boolean | return spid, for (example) kill process, default - false |\n| [check_print] | boolean | return PRINT and RAISERROR, default - false |\n| [type_ext] | boolean | create properties \"type_name\", \"type_title\", \"type_charlen\" in schema |\n\n\n\n## type\\_exec\\_lock\\_option\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| [key] | string | \n| [wait] | number | \n| [message] | string | \n\n\n\n## type\\_exec\\_lock\\_result\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| [key] | string | \n| [wait] | number | \n| [message] | string | \n| allow | boolean | \n\n\n\n## type\\_exec\\_correction\\_utc\\_option\n**Kind**: global typedef \n**Properties**\n\n| Name | Type | Description |\n| --- | --- | --- |\n| [offset] | number | correct field with datetime type by this value (in minutes) |\n| [mode] | string | which fields correct by utc offset, example - '{#all}{}{fdm;ldm}' - in first table correct all datetime fields, second table is missing, in the third table correct only two fields |\n\n\n\n## type\\_exec\\_correction\\_utc\\_result\n**Kind**: global typedef \n**Properties**\n\n| Name | Type | Description |\n| --- | --- | --- |\n| [offset] | number | correct field with datetime type by this value (in minutes) |\n| [mode] | string | which fields correct by utc offset, example - '{#all}{}{fdm;ldm}' - in first table correct all datetime fields, second table is missing, in the third table correct only two fields |\n\n\n\n## type\\_exec\\_error\\_result\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| step | number | \n| error | Error | \n| point | 'connect' \\| 'sql' \\| 'kill' \\| 'action' | \n\n\n\n## type\\_exec\\_script\\_result\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| [lock_on] | string | \n| [lock_off] | string | \n| queue | Array.<string> | \n| [name_server] | string | \n| [name_database] | string | \n| [name_database_after_exec] | string | \n| [spid] | number | \n| [spguid] | string | \n| get_plain_query | function | \n\n\n\n## type\\_exec\\_table\\_result\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| schema | Object | \n| step | number | \n| table_index | number | \n| rows | Array.<Object> | \n\n\n\n## function\\_tables\\_to\\_xml\\_file1 : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| error | Error | \n| xml | string | \n\n\n\n## function\\_tables\\_to\\_xml\\_file2 : function\n**Kind**: global typedef \n\n| Param | Type | Description |\n| --- | --- | --- |\n| [full_file_name] | string | //if empty, see xml as a string in callback |\n| table_name_list | Array.<string> | |\n| callback | [function\\_tables\\_to\\_xml\\_file1](#function_tables_to_xml_file1) | |\n\n\n\n## type\\_performance\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| perfomance_exec_before | number | \n| perfomance_exec_after | number | \n| duration_exec_millisecond | Array.<number> | \n\n\n\n## type\\_exec\\_result\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| handle_error | [type\\_exec\\_error\\_result](#type_exec_error_result) | \n| [lock] | [type\\_exec\\_lock\\_result](#type_exec_lock_result) | \n| [script] | [type\\_exec\\_script\\_result](#type_exec_script_result) | \n| [correction_utc] | [type\\_exec\\_correction\\_utc\\_result](#type_exec_correction_utc_result) | \n| performance | [type\\_performance](#type_performance) | \n| [tables] | [Array.<type\\_exec\\_table\\_result>](#type_exec_table_result) | \n| [tables_to_xml] | [function\\_tables\\_to\\_xml\\_file2](#function_tables_to_xml_file2) | \n\n\n\n## type\\_exec\\_runtime\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| type | 'spid' \\| 'print' \\| 'table' | \n| [spid] | [type\\_exec\\_spid](#type_exec_spid) | \n| [print] | [type\\_exec\\_print](#type_exec_print) | \n| [table] | [type\\_exec\\_table\\_result](#type_exec_table_result) | \n\n\n\n## type\\_exec\\_spid\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| spguid | string | \n| spid | number | \n| exists | boolean | \n| killed | boolean | \n\n\n\n## type\\_exec\\_print\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| message | string | \n| procname | string | \n| is_error | boolean | \n\n\n\n## callback\\_exec\\_part : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| error | Object | \n\n\n\n## callback\\_exec : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| result | [type\\_exec\\_result](#type_exec_result) | \n| runtime | [type\\_exec\\_runtime](#type_exec_runtime) | \n\n\n\n## callback\\_exec\\_runtime : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| runtime | [type\\_exec\\_runtime](#type_exec_runtime) | \n\n\n\n## callback\\_print : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| print | [type\\_exec\\_print](#type_exec_print) | \n\n\n\n## callback\\_table : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| table | [type\\_exec\\_table\\_result](#type_exec_table_result) | \n\n\n\n## callback\\_action : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| result | [type\\_exec\\_result](#type_exec_result) | \n| named_tables | Array.<Object> | \n| warning | Array.<string> | \n\n\n\n## callback\\_get\\_connection\\_pool : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| error | Error | \n| connection_pool | lib\\_sql.ConnectionPool | \n\n\n\n## callback\\_connect : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| error | Error | \n| connection_pool | lib\\_sql.Request | \n\n\n\n## type\\_action\\_find\n**Kind**: global typedef \n**Properties**\n\n| Name | Type |\n| --- | --- |\n| key | string | \n| title | string | \n| sql_result_list | Array.<string> | \n| note | string | \n| error_list | Array.<string> | \n\n\n\n## callback\\_get\\_newid : function\n**Kind**: global typedef \n\n| Param | Type |\n| --- | --- |\n| error | Error | \n| guid | string | \n\n","readmeFilename":"readme.md"}