what is difference between SET and SELECT in SQL Server

Question

what is difference between select and set statements while assigning a value to a variable? Which one should be used when?