SQL to insert a new column; multiple actions in a query

[Mario]

Can any body please help me with a sample code for
inserting a column into a table.

Also., can one single sql query do the following:

.....insert column.....;

....update....;


saved in one query.

Please help
Mario

 

[Michel Walsh]

Hi,



ALTER TABLE tableName ADD COLUMN columnName SHORT


since 2000, you can add a DEFAULT too, using Jet 4.0, but WITH ADO (outside
the query designer):


ALTER TABLE tableName ADD COLUMN columnName SHORT DEFAULT 0


You can also add a constraint.


You can't update at the same time.


Hoping it may help,
Vanderghast, Access MVP

 

[John Vinson]

Can any body please help me with a sample code for
inserting a column into a table.

ALTER TABLE tablename

Also., can one single sql query do the following:

....insert column.....;

...update....;

No.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps