Connect to a Microsoft® SQL Server® database and verify the database connection. Then, import data from the database into MATLAB®. Determine the highest unit cost among the retrieved products in the table. Close the database connection.

创建一个n ODBC database connection to a Microsoft® SQL Server® database with Windows® authentication. Specify a blank user name and password. The database contains the tableproductTable.

datasource ='MS SQL Server Auth';conn = database(datasource,'','');

Check the database connection. If theMessageproperty is empty, the connection is successful.

conn.Message

ans = []

Select all data fromproductTableand sort it by the product number.datais a table containing the imported data that results from executing the SQLSELECTstatement.

selectquery ='SELECT * FROM productTable ORDER BY productNumber';data = select(conn,selectquery);

Display the first three rows of data.

data(1:3,:)

ans = 3×5 table productNumber stockNumber supplierNumber unitCost productDescription _____________ ___________ ______________ ________ __________________ 1 4.0035e+05 1001 14 'Building Blocks' 2 4.0031e+05 1002 9 'Painting Set' 3 4.01e+05 1009 17 'Slinky'

Determine the highest unit cost in the table.

max(data.unitCost)

ans = 24

Close the database connection.

close(conn)

创建一个database connection using a JDBC driver. To create this connection, you must configure a JDBC data source. For more information, see theconfigureJDBCDataSourcefunction. Then, create aDatabaseDatastoreobject and close it.

创建一个database connection to the JDBC data sourceMSSQLServerJDBCAuth. This data source configures a JDBC driver to a Microsoft® SQL Server® database with Windows® authentication. Specify a blank user name and password.

datasource ="MSSQLServerJDBCAuth";用户名="";password ="";conn = database(datasource,username,password);

创建一个DatabaseDatastoreobject using the database connection and an SQL query. This SQL query retrieves all data from theairlinesmalltable.

sqlquery ="select * from airlinesmall";dbds = databaseDatastore(conn,sqlquery);

Close theDatabaseDatastoreobject and the database connection.

close(dbds)