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. |