Forum Discussion
Insert & Update both implemented wrong semantically
Insert means to introduce something, adding/entering something new Update means to change something, change and existing value. Semantically and logically speaking, Insert should only be used to en...
You should remember that T-SQL doesn't work with colums. It works with rows.
Thus, Update is syntactically correct, as it modifies existing rows.
Likewise, Insert creates new rows.