When to use SET vs SELECT when assigning values to variables in SQL Server

What if variable is not populated successfully If a variable is not successfully populated then behavior for SET and SELECT would be different. Failed assignment may be due to no result returned or any non-compatible value assigned to the variable. In thi

www.mssqltips.com