base on the syntax in sql I'm trying to insert few columns from table A into table B so it goes:
INSERT INTO table2
Now, how this syntax should change when I have a primary key and will be fed by Sql Server itself? currently I'm getting error for that as
Msg 515, Level 16, State 2, Line 2
Cannot insert the value NULL into column 'VisitorID', table 'MyDb.Visitors'; column does not allow nulls. INSERT fails.
The statement has been terminated.