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

  • Thread starter Thread starter Mario
  • Start date Start date
M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Insert Multiple Records into a Table 1
How do I execute multiple SQL statements in Access?? 3
Insert a crosstab to temp table 4
Invalid Column Name Sql-Error :Executing a stored procedure 1
Combine and Insert query 7
SQL INSERT question 1
Insert a crosstab to temp table for report 6

Back
Top