Changes to the set Command

Adaptive Server 15.0.2 introduces several changes to the set command.

set command change
set advanced_aggregation enables and disables advanced aggregation at the session level.
set switch allows you to set trace flags and switch names locally and server-wide.
The compile-time behavior has changed for some abstract plan set parameters when you use them to create stored procedures or run them in Transact-SQL batches.
The set command can include string and char_variable parameters.