variable not going into data base. SQL server 2014

Asad Ullah

2016 2 26

0 个回答

更新时间：2021 8 20

1 次查看（30 天）

Follow Question

信息

此问题已关闭。请重新打开它进行编辑或回答。

显示更早的评论

在 MATLAB Online 中打开

0 个投票

i am trying to send some variable into SQL server 2014 with MATLAB. it is sending numeric value but not sending variable or string. (code is below) Please help

variable  = 123;
conn = database('OMR','sa','123',...
'Vendor','Microsoft SQL Server','Server','MY_PC',...
'AuthType','Server','portnumber',1433);
sqlquery = 'INSERT INTO [dbo].[abc] ([q1]) VALUES (variable)';
curs = exec(conn, sqlquery);
  close(curs);
close(conn);