tsql - SQL server 2008 management studio syntax error -
i'm very new programming. i'm having hardest time seemingly simple insert statement i'm using query run. following putting in:
insert [employee table] (list of column names surrounded '' , separated ,.) values (list of data want in each column)
i can't rid of syntax complaints @ bracketed employee table. i've tried multiple combinations. i'm trying first column generate automatic number. when it's time input in column, should inserting there? should blank?
i'm guessing syntax highlighter highlighting wrong portion of statement. square brackets around table name fine. don't need ''
's surrounding column names:
insert [employee table] (firstname, lastname, isactive) values ('justin', 'niessner', 1)
Comments
Post a Comment