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, 1248🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...