I have been working with T-SQL in MS SQL for some time now and somehow whenever I have to insert data into a table I tend to use syntax:
INSERT INTO myTable <something here>
I understand that keyword INTO
is optional here and I do not have to use it but somehow it grew into habit in my case.
My question is:
- Are there any implications of using
INSERT
syntax versusINSERT INTO
? - Which one complies fully with the standard?
- Are they both valid in other implementations of SQL standard?