How do I also get headers for a table extracted in an SQL query

Question

Thomas Skov 2020-1-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500636-how-do-i-also-get-headers-for-a-table-extracted-in-an-sql-query

评论： Thomas Skov 2020-1-24

When I run:

>> results = runsqlscript(conn,'scriptfile');

I get a results output where the data is without the headers I can see when I run the same sql script via another program. How do I also get the headers in the matlab environment?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Chidvi Modala 2020-1-24

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500636-how-do-i-also-get-headers-for-a-table-extracted-in-an-sql-query#answer_411775

在 MATLAB Online 中打开

From my understanding, you are trying to get column headers from table. When the SQL script executes, it returns two cursor objects that contain the imported data from each query in a cursor object array. You can use the following example to extract column headers from a table

datasource = 'MS SQL Server Auth';
conn = database(datasource,'',''); % Create an ODBC database connection
scriptfile = 'compare_sales.sql'; % Run the SQL script
results = runsqlscript(conn,scriptfile);
data = results(2).Data; % Display the imported data for the second query.
names = columnnames(results(2)) % Retrieve column header names from the second query