組態王調用MSSQL 的存儲過程?請問哪位知道如何在組態王中調用M QL的存儲過程,並用組態王變量作為存儲過程的參數! 我嚐試了一些方法,都沒有實現成功! 存儲過程定義如下: CREATE PROCEDURE MyProc @param1 char(4),@param2 varchar(40) AS i ert stores (stor_id,stor_name) values(@param1,@param2) GO 在組態王中調用如下(其中Col1,Col2為組態王變量,Bind為定義了Col1和Col2兩列的記錄體) ResultCode = SQLCo ect( DeviceID, "d =Pu "); ResultCode = SQLSetStatement(DeviceID,"Exec MyProc "); ResultCode = SQLPrepareStatement(DeviceID,SQLHandle); ResultCode = SQLA endSatement(DeviceID,Col1); ResultCode = SQLA endSatement(DeviceID,Col2); ResultCode = SQLExecute(DeviceID,"Bind",0); SQLDisco ect( DeviceID);