DIFFERENCE BETWEEN SET AND SELECT

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1545  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    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

Answer

NEWSLETTER

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