MS SQL Server Concepts and Programming Question: Download Questions PDF
How To Retrieve Error Messages using mssql_get_last_message()?
Answers:
Answer #1When 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','GlobalGuideLine');
mssql_select_db('GlobalGuideLineDatabase', $con);
# dropping a table
$sql = 'DROP TABLE fyi.center';
$res = mssql_query($sql, $con);
if (!$res) {
print("Execution failed: ");
print(" Error: ".mssql_get_last_message()." ");
} else {
print("Execution was successful. ");
}
mssql_close($con);
?>
The tutorial script below shows you a good example:
<?php
$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');
mssql_select_db('GlobalGuideLineDatabase', $con);
# dropping a table
$sql = 'DROP TABLE fyi.center';
$res = mssql_query($sql, $con);
if (!$res) {
print("Execution failed: ");
print(" Error: ".mssql_get_last_message()." ");
} else {
print("Execution was successful. ");
}
mssql_close($con);
?>
Answer #2
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
'globalguideline', because it does not exist or you do not
have permission. (severity 11) in C: estglobalguideline.php
on line 7
Execution failed:
Error: Cannot drop the table 'fyi.center', because
it does not exist or you do not have permission.
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
'globalguideline', because it does not exist or you do not
have permission. (severity 11) in C: estglobalguideline.php
on line 7
Execution failed:
Error: Cannot drop the table 'fyi.center', because
it does not exist or you do not have permission.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Execute a SQL Statement using mssql_query()? | How To Loop through Result Set Objects using mssql_fetch_array()? |