在sql server2000里
exec select_midtable_ATMBank '2003-05-01','2003-05-31'用TADOStoredProc该怎么写?
两个参数:
startdate:='2003-05-01';
enddate:='2003-05-31';谢谢
exec select_midtable_ATMBank '2003-05-01','2003-05-31'用TADOStoredProc该怎么写?
两个参数:
startdate:='2003-05-01';
enddate:='2003-05-31';谢谢
ADOStoredProc1.Parameters.Clear;
ADOStoredProc1.ProcedureName := 'USP_AFFUSIONDAY';
ADOStoredProc1.Parameters.CreateParameter(’startdate‘, ftString, pdInput, 10, '2003-05-01');
ADOStoredProc1.Parameters.CreateParameter('enddate', ftString, pdInput, 10, '2003-05-31');
ADOStoredProc1.ExecProc;或者直接在组件上修改属性
~~~~我用的是变量,这样不是写死在里面了吗?