sql server 临时表插入空值的问题
zwk_9 2009-06-02 10:39:50 我用如下语句插入临时表
sqlstr:= 'select ''' + ADOQryProduct.FieldByName('JHID').AsString + ''' as JHID, '''
+ FieldByName('CPCODE').AsString + ''' as CPCODE, '''
+ FieldByName('WLCODE').AsString + ''' as WLCODE, '''
+ FieldByName('WLMC').AsString + ''' as WLMC, '''
+ FieldByName('TZH').AsString + ''' as TZH, '''
+ FieldByName('WLGG').AsString + ''' as WLGG, '''
+ FieldByName('WLXH').AsString + ''' as WLXH, '''
+ FieldByName('WLCZ').AsString + ''' as WLCZ, '''
+ FieldByName('WLDW').AsString + ''' as WLDW, '''
+ FieldByName('DJ').AsString + ''' as DJ, '''
+ FieldByName('MONEY').AsString + ''' as MONEY, '''
+ FieldByName('XQRQ').AsString + ''' as XQRQ into #';
exesql(frmDataModule.ADOQryComm, sqlstr);
需要插入很多条记录,其中某些记录的某些字段(并不是固定的某几个字段)为空的,结果插入不进去
该怎么处理啊?