MS SQL Server Concepts and Programming Question: Download Questions PDF
How To Select an Exiting Database using mssql_select_db()?
Answer:
The first thing after you have created a connection object to the SQL Server is to select the database where your tables are located, by using the mssql_select_db() function. If your MSSQL server is offered by your Web hosting company, they will assign an empty database to you and provide you the database name. You should use this name to select this empty database as your current database. The following script shows you how to select a database called "GlobalGuideLineDatabase".
To test the mssql_select_db() function, try the following script:
<?php
$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');
mssql_select_db('GlobalGuideLineDatabase', $con);
$sql = 'SELECT * FROM sys.tables';
if ($res = mssql_query($sql, $con)) {
print(mssql_num_rows($res) . " tables in database. ");
} else {
print("SQL failed. ");
}
mssql_close($con);
?>
You will get something like this:
10 tables in database.
To test the mssql_select_db() function, try the following script:
<?php
$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');
mssql_select_db('GlobalGuideLineDatabase', $con);
$sql = 'SELECT * FROM sys.tables';
if ($res = mssql_query($sql, $con)) {
print(mssql_num_rows($res) . " tables in database. ");
} else {
print("SQL failed. ");
}
mssql_close($con);
?>
You will get something like this:
10 tables in database.
Download MS SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Disconnect from a SQL Server using mssql_close()? | How To Execute a SQL Statement using mssql_query()? |