Hello community,
I'm trying to find a way of adding a new column to a existing table in sql server, is there an easy way? Easier than using alter table in a pre sql statement.
Thanks,
Fernando Vizcaino
Solved! Go to Solution.
Is there a particular reason you're adverse to adding a pre-SQL "ALTER TABLE" statement? It's probably the quickest and safest way to do so.
It is a dynamic workflow that distributes 20k rows x 20k columns file into a bunch of different SQL tables. Since we are having some performance issues, I was wondering if there was a way of not inserting one more possible bottleneck to the process.
But if it's the easier way, I'm gonna use it.
Thanks a lot tcroberts,
Fernando Vizcaino