MS SQL Server Concepts and Programming Question: Download Questions PDF
How To Execute a SQL Statement using mssql_query()?
Answer:
Once you have created a connection object, you can use the mssql_query() function to send a SQL statement to the SQL Server linked to the connection object for execution.
Here is a simple PHP script that creates a new schema and a new table:
<?php
$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');
mssql_select_db('GlobalGuideLineDatabase', $con);
# creating a new schema
$sql = 'CREATE SCHEMA ggl';
mssql_query($sql, $con);
# creating a new table
$sql = 'CREATE TABLE globalguideline (name VARCHAR(80))';
mssql_query($sql, $con);
mssql_close($con);
?>
If you run this script for the first time, it will execute those two statements correctly for you. But if you run it again, you will some warning messages:
Warning: mssql_query(): message: There is already an object
named 'ggl' in the database. (severity 16)
in C: estglobalguideline.php on line 7
Warning: mssql_query(): message: CREATE SCHEMA failed
due to previous errors. (severity 16)
in C: estglobalguideline.php on line 7
The messages are very clear and easy to understand.
Here is a simple PHP script that creates a new schema and a new table:
<?php
$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');
mssql_select_db('GlobalGuideLineDatabase', $con);
# creating a new schema
$sql = 'CREATE SCHEMA ggl';
mssql_query($sql, $con);
# creating a new table
$sql = 'CREATE TABLE globalguideline (name VARCHAR(80))';
mssql_query($sql, $con);
mssql_close($con);
?>
If you run this script for the first time, it will execute those two statements correctly for you. But if you run it again, you will some warning messages:
Warning: mssql_query(): message: There is already an object
named 'ggl' in the database. (severity 16)
in C: estglobalguideline.php on line 7
Warning: mssql_query(): message: CREATE SCHEMA failed
due to previous errors. (severity 16)
in C: estglobalguideline.php on line 7
The messages are very clear and easy to understand.
Download MS SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Select an Exiting Database using mssql_select_db()? | How To Retrieve Error Messages using mssql_get_last_message()? |