In T$-$SQL$,$ you have the option of using either the SELECT or SET statement to assign values to variables. Can you explain the differences between these two options? Based on your understanding, would you recommend using one over the other and why? Provide specific examples to support your recommendation.