MATLAB is not passing string type variable into SQL 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);

Answer 1

[Walter Roberson]

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

[Usama Arshad]

its working. thanks alot :-)

[Walter Roberson]

%s is a string format specifier for the sprintf() call. sprintf() is like fprintf() but returns the output to a string.