当字段名是个变量的时候如何实现添加一个字段呢,char studenName[]="张三"
pConn->Execute("ALTER TABLE mydb1 ADD COLUMN studenName LONG",NULL,adCmdUnknown);//添加字段
"ALTER TABLE mydb1 ADD COLUMN studenName LONG",这个SQL语句应该怎么写???
pConn->Execute("ALTER TABLE mydb1 ADD COLUMN studenName LONG",NULL,adCmdUnknown);//添加字段
"ALTER TABLE mydb1 ADD COLUMN studenName LONG",这个SQL语句应该怎么写???
char strSQL[MAX_PATH]={0};
sprintf(strSQL,"%s%s%s","ALTER TABLE mydb1 ADD COLUMN ",studenName," LONG"); pConn->Execute((_bstr_t)strSQL,NULL,adCmdUnknown);//添加字段
strSQL.Format("ALTER TABLE mydb1 ADD COLUMN %s LONG",studenName);
pConn->Execute((_bstr_t)strSQL,NULL,adCmdUnknown);//添加字段