public static List<String> buildAddColumnsSql(final String schemaName, final String tableName,
            List<SQLServerColumnInfo> columnList) {
        final List<String> sqls = Lists.newArrayList();
        final List<String> columnInfoList = getColumnsInfo(columnList, null);
        final StringBuilder sqlBuilder = new StringBuilder();
        if (CollectionUtils.isNotEmpty(columnList)) {
            sqlBuilder.append("ALTER TABLE ")
                    .append(schemaName)
                    .append(".")
                    .append(tableName)
                    .append(" ADD ")
                    .append(String.join(",", columnInfoList))
                    .append(" ;");
        }
        sqls.add(sqlBuilder.toString());
        columnList.stream()
                .filter(column -> StringUtils.isNotEmpty(column.getComment()))
                .forEach(column -> {
                    sqls.add(
                            buildAddColumnComment(schemaName, tableName, column.getName(), column.getComment()));
                });
        LOGGER.info("add columns sql={}", sqls);
        return sqls;
    }
Build add columns SQL.

@param schemaName SQLServer schema name
@param columnList SQLServer column list {@link List}
@return add column SQL string list
inlong-manager/manager-service/src/main/java/org/apache/inlong/manager/service/resource/sink/sqlserver/SQLServerSqlBuilder.java