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

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

Nuget pack csproj using nuspec -