how to update?

P

Praveen Manne

Hi,

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

Please Help

Praveen Manne
 
R

Rick B

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
 
P

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

How to automate update on weekly reports spreadsheet 0
Consolidation Table from Different Excel Tabs with Different Format 1
Create tool bar 2021 0
How to display zero value in blank fields of Cross Tab query 0
Forum Category Update 0
Integrating information from Word to Excel (not mail merge) 1
Copy a table query 1
Using DSUM to get running total on a filtered form 0

Top