SQL Server: Truth about assigning variables using SET versus SELECT

In this post, I am sharing the major difference between SET and SELECT, which we are using for assigning a value to the Variable of SQL Server. What I have found is, the people are always confused to use SET or SELECT for assigning a value to the Variable and which one is faster ? … Continue reading SQL Server: Truth about assigning variables using SET versus SELECT