How many columns can MS-SQL insert into a data field at a time?

harryxu84

I have a multi-column data that needs to be inserted into a database field. There are about 100 columns. Each insertion prompts a data adapter error, but deleting some fields and then operating is fine. What is the maximum number of columns allowed for the insertion of a record?

fanfan1980

A table can have a maximum of 1024 columns

fanfan1980

Should be independent of the number of columns, whether the data types do not match

harryxu84

Thanks