if(rest->State == adStateOpen)
{
rest->Close();
}
sql语句:
sql = “select * from sysobject where name = 'newTable'”;
rest->open(......)
if(rest->adoEOF())
{
// 新建表的sql
sql = 。。。
try
{
pCommand->Execute();
}
catch(_com_error &e)
{
}
}
2、升级表
if(rest->State == adStateOpen)
{
rest->Close();
}
sql = “select * from syscolumns where id = object_id('table name ') and name ='columnname'”;
try{
rest->open(sql,,,,,,,);
}
catch(_com_error &e)
{
rest->close();
conn->close();
}
if(rest->adoEOF)
{
sql = "alter table tablename add newColumns not null";
pCommand->CommandText = sql;
try
{
pCommand->Execute();
}
catch(_com_error &e)
{
}
}
|
|