how to update?

  • Thread starter Thread starter Praveen Manne
  • Start date Start date
P

Praveen Manne

Hi,

How to update all records in a table to their default values using SQL
statement?

Please Help

Praveen Manne
 
Create an update query and tell it what value you'd like to change each
record to.

Rick B


Hi,

How to update all records in a table to their default values using SQL
statement?

Please Help

Praveen Manne
 
In my table I have around 215 fields .. it is very difficult to specify all
of them .. is there any sql statement by which i can change all the fields
without explicitly specifying all of them ?
 

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

Copy a table query 1
Using Combo Boxes 5
Criteria is NULL 4
DataSheet 3
Modal form 1
How to get the value in previous record to current record? 4
Call a Javascript function from C# 7
Manipulate records of 2 tables 11

Back
Top