how to update columns in SQL server in windows application

Question

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 ....???

Amit Gupta · Answer

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

Amit Gupta · Answer

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

Amit Gupta · Answer

It was quite a very simple logic (as there are many). Execute the query at your form load on a separate thread.

Jyoti Jodha · Answer

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…..????

Rafnas T P · Answer

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 Jodha · Answer

What is Code Write in windows application….??? when it runs it will add your 2 columns in database