MATLAB: MATLAB is not passing string type variable into SQL SERVER 2014

sql serversql server 2014

abc = 'abcdef';
conn = database('databasename','user id','password',...
'Vendor','Microsoft SQLServer', 'Server', '(local)', 'AuthType', 'Server', 'portnumber', 1433);
query = 'INSERT INTO table_Name (column_Name) VALUES (abc)';
curs = exec(conn,query );
close(curs);
close(conn);

Best Answer

query = sprintf( 'INSERT INTO table_Name (column_Name) VALUES (''%s'')', abc);