DIFFERENCE BETWEEN SET AND SELECT

Amit Singh

Total Post:562

Points:2810
Posted by  Amit Singh
 1618  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:562

    Points:2810
    Difference between Set and Select

    Difference between Set and Select

    1. Set is a ANSI standard for variable assignment.
    2. Select is a Non-ANSI standard when assigning variables.

    1. We can assign only one variable at a time
    2. We can assign multiple variable at a time

    1. When assigning from a query that returns more than one value, SET will fail with an error.
    2. When assigning from a query that returns more than one value, SELECT will assign the last value returned by the query and hide the fact that the query returned

      Modified On Mar-26-2018 06:05:01 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!