Append new column via a script

[ChewDoggie]

Hello All,

I have added a few new columns to a SQL table during the development cycle and now have to create a script that accomplishes the same on my client's machine. I will not be there when this occurs, so it has to occur seamlessly.

how do I append columns to a Table using T-SQL (in a script) ?

Thanks !

Chew


10% of your life is what happens to you. 90% of your life is how you deal with it.

 

[SQLBill]

Is this what you are looking for:

ALTER TABLE tablename ADD columnname datatype

ex: ALTER TABLE myTable ADD newColumn VARCHAR(10) NULL

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[ChewDoggie]

Yes !

I created a simple script with a line that looks like this:

osql -UAdminAccnt -PPassword -dDatabaseName -Q"ALTER TABLE myTable ADD newColumn VARCHAR(10) NULL"

and gave it a .bat file extension. It **SEEMS** to execute OK, but my app keeps barfing with "Invalid Column Name newColumn". Am I giving my file the right file extension, and if not, where should this file be executed from ?

Thansk !

Chew

10% of your life is what happens to you. 90% of your life is how you deal with it.

 

[SQLBill]

I don't know about having a .bat extension. You should just be able to run the script as it is in the code window.

I use a SQL Server query window and run the T-SQL, so I'm not sure what needs done to run an osql command from an app.

One thing to check is the schema being used. Is the table created in the dbo schema (dbo.tablename). If not, then your app will need to preface any commands with the proper schema name -for example: Chew.tablename

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[simian336]

I usually put my query into a .sql file then launch the .sql file with a .bat file like

osql -U sa -P password -i c:\query.sql

Simi

 

[ChewDoggie]

Thanks, SQLBill / Simian ! I'll let you know what works.

Chew


10% of your life is what happens to you. 90% of your life is how you deal with it.