用ADO访问数据库时，如何拼写动态SQL

Question

用ADO访问数据库时，如何拼写动态SQL
CString code = "...";
m_pRecordset->open("select * from table_name where col_name = ...",...);

Answer 1

CString sqltext="SELECT * FROM view_procedure WHERE product_no=60";
m_pRecordset->Open((_variant_t)sqltext,
                     _variant_t((IDispatch*)theApp.m_pConnection,true),
                     adOpenStatic,
                     adLockOptimistic,adCmdText);