matlab调用数据库,matlab调用SQL数据库代码示例(ODBC)

function [rtn dt name] = getsqldata(code,dtstart,dtend)

% code = '600000';

% dtstart = '2009-01-01';

% dtend = '2009-12-30';

%convert(varchar,b.tradingday,101) as dt

setdbprefs('datareturnformat','cellarray');

k = 0;

on = 1;

while(k <= 3 && on)

conn = database('jydb','sa','qwe123');

if conn.AutoCommit=='on'

on = 0;

end

k = k+1;

end

str1 = sprintf(['drop table rtntran DECLARE @StartDate DATETIME,@EndDate DATETIME,@StockCode VARCHAR(20) '...

'SET @StartDate = ''%s'' SET @EndDate = ''%s'' SET @StockCode = ''%s'' '...

'select distinct b.secucode,b.secuabbr,b.innercod