CODEWITHSUNDEEP
sql
Aaron
Aaron

Reputation: 151

Can an update statement do all the follow?

I'm doing the revision questions for my database course and I can't work out which question is false.

  1. The keyword SET can be followed by multiple assignment expressions

  2. If the join operation is used, an update statement can update multiple tables

  3. The keyword update is followed by one and only one table name

  4. The where clause can be omitted.

I'm thinking no 3 is the false one but I'm not sure why. I'm guessing where attributes are the same it can join multiple tables.

Upvotes: 0

Views: 74

Answers (1)

Hart CO
Hart CO

Reputation: 34774

For SQL Server, I believe:

  1. The keyword SET can be followed by multiple assignment expressions = True

  2. If the join operation is used, an update statement can update multiple tables = False

  3. The keyword update is followed by one and only one table name = True

  4. The where clause can be omitted. = True

Upvotes: 1

Related Questions