How do I view the Bind variables from a PHP Prepared Statement on SQL Server 2012? -
i have read question oracle's bind equivalent. 4 years later, however. have looked @ sp_executesql from
https://msdn.microsoft.com/en-us/library/ms188001.aspx?f=255&mspperror=-2147217396
i not using t-sql or sort of stored procedure, php prepared statement (using pdo).
how can view bound value in sql server 2012? if there way me use sp_executesql, not know how use it.
edit: when view, mean table in sql server.
edit: trying find out value received sql server. want query view, table, run stored procedure, can see sql server received.
here similar question: what sql server equivalent of oracle bind variables in dynamic sql?
this in oracle 11g:
http://docs.oracle.com/cd/b19306_01/server.102/b14237/dynviews_2114.htm#refrn30310
"v$sql_bind_capture displays information on bind variables used sql cursors. each row in view contains information 1 bind variable defined in cursor. includes:"
edit: example,
$sql = "select * employees employeeid = :mykey"; $prepared_statement = $this->_adapter->prepare($sql); $prepared_statement->bindvalue(':mykey', $_employee_search, pdo::param_int); $prepared_statement->execute();
i wan know :mkey
after has been sent sql server.
Comments
Post a Comment