Variables in Transact-SQL procedures

SQL Anywhere uses the SET statement to assign values to variables in a procedure. In Transact-SQL, values are assigned using
either the SELECT statement with an empty table-list, or the SET statement. The following simple procedure illustrates how
the Transact-SQL syntax works: