On, Off

Off

On for Sybase Open Client and jConnect connections

Can be set for an individual connection, or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role.

When this option is set to On, you can use the @ sign instead of the colon as a prefix for host variable names in embedded SQL. This is implemented primarily for Transact-SQL compatibility.

• Compatibility options
• sp_tsql_environment system procedure
• tsql_variables connection property