SET |
Fixe |
|---|---|
| Sybase | |
Syntaxe
| SET @variable = expression [, @variable = expression...] |
| SET ansinull {on | off} |
| SET ansi_permissions {on | off} |
| SET arithabort [arith_overflow | numeric_truncation] {on | off} |
| SET arithignore [arith_overflow] {on | off} |
| SET bulk array size number |
| SET bulk batch size number |
| SET {chained, close on endtran, nocount, noexec, parseonly, procid, self_recursion, showplan, sort_resources} {on | off} |
| SET char_convert {off | on [with {error | no_error}] | charset [with {error | no_error}]} |
| SET cis_rpc_handling {on | off} |
| SET [clientname client_name | clienthostname host_name | clientapplname application_name] |
| SET cursor rows number for cursor_name |
| SET {datefirst number, dateformat format, language language} |
| SET delayed_commit { on | off | default } |
| SET fipsflagger {on | off} |
| SET flushmessage {on | off} |
| SET forceplan {on | off} |
| SET identity_insert [database.[owner.]]table_name {on | off} |
| SET identity_update table_name {on | off} |
| SET lock { wait [ numsecs ] | nowait } |
| SET metrics_capture on/off |
| SET offsets {select, from, order, compute, table, procedure, statement, param, execute} {on | off} |
| SET option show |
| SET parallel_degree number |
| SET plan {dump | load } [group_name] {on | off} |
| SET plan exists check {on | off} |
| SET plan for show |
| SET plan optgoal allrows_mix | allrows_dss |
| SET plan opttimeoutlimit number |
| SET plan replace {on | off} |
| SET prefetch [on|off] |
| SET proc_output_params on | off |
| SET proc_return_status on | off |
| SET process_limit_action {abort | quiet | warning} |
| SET proxy login_name |
| SET quoted_identifier {on | off} |
| SET repartition_degree number |
| SET resource_granularity number |
| SET role {"sa_role" | "sso_role" | "oper_role" | role_name [with passwd "password"]} {on | off} |
| SET {rowcount number, textsize number} |
| SET scan_parallel_degree number |
| SET session authorization login_name |
| SET statistics {io, subquerycache, time, plancost} {on | off} |
| SET statistics simulate { on | off } |
| SET strict_dtm_enforcement {on | off} |
| SET string_rtruncation {on | off} |
| SET textsize {number} |
| SET transaction isolation level { [ read uncommitted | 0 ] | [ read committed | 1 ] | [ repeatable read | 2 ]| [ serializable | 3 ] } |
| SET transactional_rpc {on | off} |
Description
Cette instruction permet de fixer les options de la base de données «Sybase».
Dernière mise à jour : Dimanche, le 31 mai 2015