I have been working with TSQL in MSSQL 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 versus INSERT INTO?
- Which one complies fully with the standard?
- Are they both valid in other implementations of SQL standard?