How Do I Create A Prepared Statement In Node.JS For MSSQL?

I need to insert a string defined in Javascript into an MSSQL table. This is what I have so far: Javascript: var message = 'It's a great day today!'; $.post('www.server.com/messa

Solution 1:

If you are using the Tedious cross-platform MSSQL driver implementation, the documentation is here: http://tediousjs.github.io/tedious/parameters.html

Basically you prepare a SQL statement with '@xxx' placeholders for values you need to inject, the you bind the actual values of those parameters to your request, then execute your request.