On 7/19/06, Jun Li <[EMAIL PROTECTED]> wrote:
I was going to run the sql script generated from
Platform.getCreateTablesSql() on SQL Server 2000, however, the SQL Query
Analyzer complains about the variable names declared in the script.
"The variable name '@tablename' has already been declared. Variable names
must be unique within a query batch or stored procedure."
This variable came from MSSqlBuilder.dropTable().
I thought DdlUtils might need to use table specific variables in
this kind of statement so that the sql generated can be run on DB directly
rather than through JDBC.
Yes, sure. Can you perhaps send me the SQL so that I can debug this ?
Tom