sql – Only reading one statement from multiple insert statements

Your PhoneNumber column appears to be using the int data type, which has a max value of 2147483647. All but your 2nd insert statement have a number larger than this. You should change the data type to one that will accept those numbers, such as bigint. However int/bigint is the wrong datatype for a phone number in the first place.

As an aside, you don’t need multiple INSERT statements, you can put a comma after each row to insert such as:

INSERT INTO [table] (column1, column2, column3) 
VALUES 
(value1c1, value1c2, value1c3),
(value2c1, value2c2, value2c3)
...

Read more here: Source link