how to update columns in SQL server in windows application

Jyoti Jodha

how to update columns in SQL server

if we want to update columns in SQL server database

and SQL server is install in client system and we add 2 new columns in your database

we give windows application updation and add two new columns in client database

what to do in windows application ....???

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
It was quite a very simple logic (as there are many). Execute the query at your form load on a separate thread.
Rafnas T P8y ago
hi,
you sholud not add column while running your application, and should add more columns into table make it less as possible, if you want you can insert rows in table
Jyoti Jodha8y ago
What is Code Write in windows application….???

when it runs it will add your 2 columns in database
Amit Gupta8y ago
If you had centralized database then doing one command will reflect to all but if you had installed individual database then you must have to update each. Write this code in your application and when it rans it will add your 2 columns
Jyoti Jodha8y ago
If we have 200 clients

And we add 2 columns in database SQL server

Now how to to update SQL server database of all clients

One by one update not possible

Then what to do for this…..????
Amit Gupta8y ago
You can use alter to add column
IF COL_LENGTH('table_name', 'column_name') IS NULL
BEGIN
    ALTER TABLE table_name
    ADD [column_name] INT
END
Change your tablename and columnname accordingly