Query: mssql_execute
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
MSSQL_EXECUTE(3) MSSQL_EXECUTE(3) mssql_execute - Executes a stored procedure on a MS SQL server databaseSYNOPSISmixed mssql_execute (resource $stmt, [bool $skip_results = false])DESCRIPTIONExecutes a stored procedure on a MS SQL server databasePARAMETERSo $stmt - Statement handle obtained with mssql_init(3). o $skip_results - Whenever to skip the results or not.EXAMPLESExample #1 mssql_execute(3) example <?php // Create a new statement $stmt = mssql_init('NewBlogEntry'); // Some data strings $title = 'Test of blogging system'; $content = 'If you can read this, then the new system is compatible with MSSQL'; // Bind values mssql_bind($stmt, '@author', 'Felipe Pena', SQLVARCHAR, false, false, 60); mssql_bind($stmt, '@date', '08/10/2008', SQLVARCHAR, false, false, 20); mssql_bind($stmt, '@title', $title, SQLVARCHAR, false, false, 60); mssql_bind($stmt, '@content', $content, SQLTEXT); // Execute the statement mssql_execute($stmt); // And we can free it like so: mssql_free_statement($stmt); ?>NOTESNote If the stored procedure returns parameters or a return value these will be available after the call to mssql_execute(3) unless the stored procedure returns more than one result set. In that case use mssql_next_result(3) to shift through the results. When the last result has been processed the output parameters and return values will be available.SEE ALSOmssql_bind(3), mssql_free_statement(3), mssql_init(3). PHP Documentation Group MSSQL_EXECUTE(3)
Related Man Pages |
---|
sqlsrv_execute(3) - php |
maxdb_stmt_store_result(3) - php |
db2_num_fields(3) - php |
mssql_init(3) - php |
sqlsrv_cancel(3) - php |
Similar Topics in the Unix Linux Community |
---|
Oracle stored procedure. |
calling a PL/SQL stored procedure from KSH |
How to call sqlloader from stored procedure!!! Advise |
If statement is not working in KSH |
When should i use [] or [[]]? |