如题:
数据库为SQL2008
数据库连接:
strConnect= "Provider=SQLOLEDB.1; Server=****; Database=***; uid=***; pwd=***";
m_pConnection->Open(strConnect,"","",adModeUnknown);
// 创建记录集对象
m_pRecordset.CreateInstance(__uuidof(Recordset));
SQL执行调用:
_bstr_t StrSql(_T("WITH T_ALL AS \
( \
SELECT distinct 库房ID,物料ID,货位ID,0 AS 零 \
FROM \
( \
SELECT 库房ID,货位ID,物料ID \
FROM 物管_入库单 WITH(NOLOCK) \
WHERE [物料编码]='"+ m_No +"' \
And 入库时间<'" + m_NoDate +" 00:00:01' \
UNION ALL \
。
) AS 所有 \
) \
数据库为SQL2008
数据库连接:
strConnect= "Provider=SQLOLEDB.1; Server=****; Database=***; uid=***; pwd=***";
m_pConnection->Open(strConnect,"","",adModeUnknown);
// 创建记录集对象
m_pRecordset.CreateInstance(__uuidof(Recordset));
SQL执行调用:
_bstr_t StrSql(_T("WITH T_ALL AS \
( \
SELECT distinct 库房ID,物料ID,货位ID,0 AS 零 \
FROM \
( \
SELECT 库房ID,货位ID,物料ID \
FROM 物管_入库单 WITH(NOLOCK) \
WHERE [物料编码]='"+ m_No +"' \
And 入库时间<'" + m_NoDate +" 00:00:01' \
UNION ALL \
。
) AS 所有 \
) \
可能和ADO文件版本有关