Question: 1/ Format Columns You now run scripts to clean up the formatting of your columns. You will run these scripts on each appropriate column in

1/ Format Columns You now run scripts to clean up the formatting of your columns. You will run these scripts on each appropriate column in your IMPORT_ EMPLOYEE and IMPORT PURCHASE tables. You do this so you can simplify your SQL in a later step for updating your keys. i. Use the following UPDATE example for each text column in both import tables to make that text column in ProperCase; and to remove leading and trailing spaces UPDATE import_table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
