Thursday, May 5, 2016

When doing an INSERT in T-SQL you cannot insert specifying numeric positions of columns instead of column names.

Apparently there is a way to do an insert specifying nothing at all assuming you are to use every column in order. Just leave out the first set of parenthesis. This suggests an example might be:

INSERT INTO INVOICE VALUES( 1,1,'KEYBOARD',1,15,5,75);

No comments:

Post a Comment