Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
How To Execute a SQL Statement using odbc_exec()?
Submitted by: AdministratorOnce 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.