MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Execute a SQL Statement using odbc_exec()?

Answer:

Once you have created an ODBC connection object, you can use the odbc_exec() 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 = odbc_connect('ggl_SQL_SERVER','sa','GlobalGuideLine');

# creating a new schema
$sql = 'CREATE SCHEMA fyi';
odbc_exec($con, $sql);

# creating a new table
$sql = 'CREATE TABLE fyi.center (name VARCHAR(80))';
odbc_exec($con, $sql);

odbc_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: odbc_exec(): SQL error: [Microsoft]
[ODBC SQL Server Driver][SQL Server]
There is already an object named 'fyi' in the database.,
SQL state S0001 in SQLExecDirect in C: estggl_center.php
on line 6

Warning: odbc_exec(): SQL error: [Microsoft]
[ODBC SQL Server Driver][SQL Server]
There is already an object named 'center' in the database.,
SQL state S0001 in SQLExecDirect in C: estggl_center.php
on line 10

The messages are very clear and easy to understand.

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
How To List All DSN Entries on Your Local Machine using odbc_data_source()?How To Retrieve Error Messages using odbc_errormsg()?