P Praveen Manne Jun 28, 2004 #1 Hi, How to update all records in a table to their default values using SQL statement? Please Help 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 Jun 28, 2004 #2 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
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 Jun 28, 2004 #3 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 ?
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 ?