Collections:
mssql_get_last_message() - Retrieving Error Messages
How To Retrieve Error Messages using mssql_get_last_message()?
✍: Guest
When you call mssql_query() to execute a SQL statement, and the execution failed on the SQL Server, you can use mssql_get_last_message() function to retrieve the error messages.
The tutorial script below shows you a good example:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); # dropping a table $sql = 'DROP TABLE fyi.center'; $res = mssql_query($sql, $con); if (!$res) { print("Execution failed:\n"); print(" Error: ".mssql_get_last_message()."\n"); } else { print("Execution was successful.\n"); } mssql_close($con); ?>
If you run this script for the first time, you will get this output:
Execution was successful.
If you run this script again, the SQL statement will fail on the SQL Server, and you will get:
Warning: mssql_query(): message: Cannot drop the table 'fyi.center', because it does not exist or you do not have permission. (severity 11) in C:\test\fyi-center.php on line 7 Execution failed: Error: Cannot drop the table 'fyi.center', because it does not exist or you do not have permission.
⇒ Turning Off PHP Warning Messages for MSSQL Connection
⇐ mssql_query() - Executing SQL Statements
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-04-07, 1365🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...