Error running datainsert to insert row in sqlserver database
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hello,
I'm trying to insert a row into my sql server database using datainsert but I keep getting errors everytime I run.
![Annotation 2019-05-13 003654.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/219100/Annotation%202019-05-13%20003654.png)
I know my connection is correct as it works in fetching data.
conn = database('SqlServer','','');
data = {1 'Deposit' 500};
columns = {'CardID' 'Type' 'Amount'};
table = 'HakunaMatata.dbo.Transcations';
datainsert(conn,table,columns ,data);
close(conn);
0 Commenti
Risposte (0)
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!