Add column names to VALUES list for INSERT INTO statement generation
When generating the INSERT INTO statement after typing INSERT INTO [TableName] and hitting tab, it would be helpful in the VALUES list, in addition to showing the default value, if the column name was included. For example -
INSERT INTO Users
VALUES (DEFAULT /ID/, '' /FirstName/, '' /LastName/)
This way, for wide tables, you don't have to count column to keep track of which column you are working with.
2
votes
par20pinspot
shared this idea
-
yair commented
it would be better to change default format to new row for each value and field.