MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario descargar pdf (Pagina 548)

100

101

7 Functions — Alphabetical List

7-118

Commit the data.

sqlquery = 'commit';

exec(conn,sqlquery);

After finishing with the cursor object, close it.

curs = ans;

close(curs)

Change the Database Connection Catalog

Change the catalog for the database connection conn to intlprice.

sqlquery = 'Use intlprice';

curs = exec(conn,sqlquery);

After finishing with the cursor object, close it.

close(curs)

Create a Table and Add a New Column

Use the SQL CREATE command to create the table.

sqlquery = ['CREATE TABLE Person(LastName varchar, '...

'FirstName varchar,Address varchar,Age int)'];

Create the table for the database connection object conn.

exec(conn,sqlquery);

Use the SQL ALTER command to add a new column, City, to the table.

sqlquery = 'ALTER TABLE Person ADD City varchar(30)';

curs = exec(conn,sqlquery);

After finishing with the cursor object, close it.

close(curs)

Call a Stored Procedure Without Input and Output Arguments

Using a Microsoft SQL Server database, run a stored procedure using the native ODBC

database connection conn.

1 2 ... 543 544 545 546 547 548 549 550 551 552 553 ... 683 684

Comentarios a estos manuales

Sin comentarios

MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario Pagina 548

Comentarios a estos manuales

Relacionado con productos y manuales para Software MATLAB DATABASE TOOLBOX RELEASE NOTES