The excel file will be auto-created when running this program.
Use in excel column "修改註記V"
Tag | Description |
---|---|
AT | Create Table |
A | Add Column |
D | Delete Column |
C | Change Column Name |
M | Modify Column Type |
- Collect "AT" tag rows and build create table command string.
- Collect "A", "D", "C", "M" tag rows and build alter column command string and stored procedure.
- Collect all tag rows and build command string.
- Actually the function is 1 + 2.
- Copy the content of the text area.