SQL Command Builder

The excel file will be auto-created when running this program.

Tags

Use in excel column "修改註記V"

Tag	Description
AT	Create Table
A	Add Column
D	Delete Column
C	Change Column Name
M	Modify Column Type

Functions

1. Create Table

• Collect "AT" tag rows and build create table command string.

2. Alter Column

• Collect "A", "D", "C", "M" tag rows and build alter column command string and stored procedure.

3. Create and Alter

• Collect all tag rows and build command string.
• Actually the function is 1 + 2.

4. Copy Content

• Copy the content of the text area.