Avatar of bfuchs
Flag for United States of America

asked on 

Bulk Updates

Hi Experts,

I'm looking to write SQL statements affecting all tables of my database.
For example

A- Create a new field for each table Named DateExported (DateTime)
B- Set that DateExported field to today's date for all records in all tables.
C- Write some SQL like the following, "Delete * from ...(each table name here) Where DateExported is null"

How can these be accomplished the easiest way?

I recall doing that in excel a while back, by setting a formula and dragging down to all rows but dont remember exactly the formula.
I do have an excel sheet containing all my table names.

Thanks in advance
Microsoft OfficeDatabasesMicrosoft SQL ServerMicrosoft ExcelSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon