在php中调用ms sql存储过程
functiongeneratedoccode(){ $wf_id=self::workflow_id; $doc_code=; $link=mssql_connect($this->cfg->db->params->host,$this->cfg->db->params->username,$this->cfg->db->params->password)ordie(can'tconnectsqlserver); mssql_select_db($this->cfg->db->params->dbname,$link)ordie(selectdatabasefailure); $stmt=mssql_init(generatedoccode,$link)ordie(initializestoredprocedurefailure); mssql_bind($stmt,@wf_id,$wf_id,sqlint4); mssql_bind($stmt,@doc_code,$doc_code,sqlvarchar,true); mssql_execute($stmt,false); //printdoccodeis:.$doc_code; return$doc_code; }
先调用mssql_init语句用于初始化存储过程，而后调用mssql_bind语句指定存储过程参数，最后调用mssql_execute执行存储过程。