Problem with Columns added with Alter Table

Question

Hi,

i created a table in TSQL (MSSQL) and im using a BULK-Import to add data. After that i alter the table and add new columns, because if i add the columns before the BULK-Insert, its not working. The import-file does not have the new columns included.

the problem is, that i cant work with the new columns, even if i put a go after the 'alter table'.

SSMS is underlining the new columns. In our test environment its working sometimes but not on our live-system.

Does anyone have an idea, want i can do?

thank u for your help

Janno

Answer 1

SSMS is underlining the new column

SSMS is a little bit "stupid" tool and not aware of your ALTER command. Go to menue "Edit" => "IntelliSense" => "Refresh cache".

And just because SSMS unerline the column, it doesn't mean you can not use/address the new column.

Olaf

Answer 2

Hi @Grigo, Jan-David

The problem you're experiencing has little to do with using BULK-Import. After creating a new table and entering data using insert into, a new column is added, and the underline also appears when operating on the newly added column.

For this problem, you can try the method provided by Olaf Helper.

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Answer 3

As Olaf says, SSMS is not SQL Server. If SSMS gives you read squiggles, you should still let SQL Server have the final say.

However, a better approach is to use a format file with your BULK INSERT. In that case, you don't need do this kludge, but you can have the colunms in place from the start.

I have an article about the bulk-load tools on my web site, which you may find helpful. It discusses format files in depth. https://www.sommarskog.se/bulkload.html

Answer 4

Thank you very much for your help. i'll try your solutions.

have a great day

Janno