Unification of syntax for update and insert commands

Question

Hello.
Is it time to unify command syntax?

Classic insert as update

INSERT table_name
SET column1 = value1, column2 = value2, ...

Insert as update from select

INSERT table_name
SET column1 = other_table.colum1, column2 = other_table.colum2, ...
FROM other_table 
WHERE condition;

Benefits:

- unified syntax with update command
- clearer parameters
- Convenient search for errors in SQL statements

Have a nice day

Zdenek

Answer 1

IMHO nope

MP

Answer 2

With the current approach you are able to insert more than one row at once.

---

Robert Haken, Microsoft MVP ASP.NET/IIS, HAVIT, s.r.o., www.havit.cz, http://knowledge-base.havit.cz