How to combine component parts in SET from UPDATE?

Question

Transact SQL

SqlCommand command = new SqlCommand("UPDATE [Library] SET [Title] = @Title AND [Tags] = @Tags AND [Body] = @Body WHERE [Id] = @Id", sqlConnection);

AND Right?
or a comma instead?

Answer 1

You do not confuse a toaster with Google.

Answer 2

Commas of course, this is not a condition!
See examples