MATLAB DATABASE TOOLBOX RELEASE NOTES Betriebsanweisung PDF herunterladen (Seite 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

Kommentare zu diesen Handbüchern

Keine Kommentare

MATLAB DATABASE TOOLBOX RELEASE NOTES Betriebsanweisung Seite 548

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software MATLAB DATABASE TOOLBOX RELEASE NOTES