SET SERVEROUTPUT Synopsis The SERVEROUTPUT setting controls whether SQL*Plus prints the output generated by the DBMS_OUTPUT package from PL/SQL procedures. Syntax SET SERVEROUT[PUT] {OFF | ON} [SIZE buffer_size] [FOR[MAT] {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}] Parameters SET ...
Changes DNS server scavenging settings. Syntax PowerShell复制 Set-DnsServerScavenging[-ApplyOnAllZones] [-ComputerName <String>] [[-ScavengingState] <Boolean>] [[-RefreshInterval] <TimeSpan>] [[-ScavengingInterval] <TimeSpan>] [[-NoRefreshInterval] <TimeSpan>] [-PassThru] [-CimSession <CimSe...
syntaxsql複製 SETFMTONLY{ON|OFF} 備註 當FMTONLY是ON時,會傳回一個含資料行名稱的資料列集,但不含任何資料列。 剖析Transact-SQL 批次時,SET FMTONLY ON沒有任何作用; 在執行階段的執行期間才會發生效果。 預設值是OFF。 權限 需要public 角色中的成員資格。
syntaxsql 复制 SET FMTONLY { ON | OFF } 备注当FMTONLY 为ON 时,返回包含列名称但不含任何数据行的行集。分析Transact-SQL 批时,SET FMTONLY ON 无效。 在执行运行时期间生效。默认值是 OFF。权限要求具有 public 角色的成员身份。示例以下Transact-SQL 代码示例将 FMTONLY 设置为 ON。 此设置使 SQL ...
syntaxsql 複製 ALTER DATABASE { database_name | CURRENT } SET { <option_spec> [ ,...n ] [ WITH <termination> ] } <option_spec> ::= { <accelerated_database_recovery> | <auto_option> | <automatic_tuning_option> | <change_tracking_option> | <containment_option> | <cursor_option...
Use the Set-OwaVirtualDirectory cmdlet to modify existing Outlook on the web virtual directories that are used in Internet Information Services (IIS) on Exchange servers. For information about the parameter sets in the Syntax section below, see Exchange cmdlet syntax.Syntax...
syntaxsql复制 SETSHOWPLAN_ALL{ON|OFF} 备注 SET SHOWPLAN_ALL 的设置是在执行或运行时设置,而不是在分析时设置。 如果SET SHOWPLAN_ALL为 ON,则 SQL Server 将返回每个语句的执行信息但不执行语句,并且 Transact-SQL 语句不会执行。 该选项设置为 ON 后,将返回有关所有后续 Transact-SQL 语句的信息,直到该选...
Syntaxstage fn="set-variable" [{insert|set|remove}-pblock="name=value" ...][name="value" ...] ParametersThe following table describes parameter values for the set-variable function.Table 7–117 set-variable Parameters Value Description pblock Specifies one of the following session or ...
Syntax set::= Description of the illustration set.eps (setRmanOption::=, setRunOption::=) setRmanOption::= Description of the illustration setrmanoption.eps (deviceSpecifier::=, formatSpec::=) setRunOption::= Description of the illustration setrunoption.eps (deviceSpecifier::=, formatSpec...
syntaxsql 复制 ALTER DATABASE { database_name | CURRENT } SET { <option_spec> [ ,...n ] [ WITH <termination> ] } <option_spec> ::= { <accelerated_database_recovery> | <auto_option> | <automatic_tuning_option> | <change_tracking_o...