我在想使用CakePHP运行Microsoft SQL Server存储过程时,这是否是正确的语法。在CakePHP中执行存储过程的语法是否正确?
存储过程具有以下参数:
$this->Main->query("Exec uspGetVendorVehicleManifest '1/6/2014', 'wali.americantour', @pcolVehicleVendorIDInt = 1,@pRouteFrom = 0, @pRouteTo = 0");
存储过程具有以下参数:
@pDate AS DATE,
@pUserID AS VARCHAR(50),
@pRegionIDInt AS INT,
@pPortIDInt AS INT,
@pcolVehicleVendorIDInt AS INT,
@pStartRow AS INT,
@pMaxRow AS INT,
@pLoadType AS INT,
@pOrderby AS VARCHAR(20),
@pRouteFrom AS TINYINT,
@pRouteTo AS TINYINT,
@pCityFrom AS VARCHAR(5),
@pCityTo AS VARCHAR(5),
@pStatus AS VARCHAR(4),
@pRole AS VARCHAR(50)
我只使用了一些参数,因为其他参数并不重要。
这样说对吗?