sql server - Insert manually into a table by SQL statement, but key is autoincremented

Question

Let's say I have a table of users and the id column is the primary key and auto incremented.

I want to just try and add user manually by this statement:

INSERT INTO table_name (id, username, password)  
VALUES (?, Mike, Mike);

but I don't want to specify the ? value, just want to add to the next row.

Thanks everyone, I forgot to set the id column to auto increment. it works now.

Answer 1

So just don't use it...do it like this..

And be sure you use single quotes for inserting strings

INSERT INTO table_name (username, password)
VALUES ('Mike', 'Mike');

As you said your field is auto incremented, SQL will automatically increment the value of the id field by 1