Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2016
    Posts
    2

    Unanswered: Data Validation best practices

    Is it best practice to run 100 queries of inserts/deletes/updates on a census style table with about 50 columns?

    It seems like a long ordered sequence to run 100 queries all at once like that. They do it every time they isolate a problem data entry and make the change.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Yes that is fine.
    But they don't run all at once, they run 1 at a time.
    This helps locate errors if needed.

    Tho I wonder if you need 50 fields. A better design may be a sub table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •