Create Node.js apps using SQL Server on Windows
1 Setup SQL Server
Setup basic installation type, read and Accept the license terms, Select installation location, Install
2 Install Chocolately and Node.js on Windows 10 using command prompt (cmd)
@"%SystemRoot%\System32\WindowsPowerShell\v1.0\powershell.exe" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin"
3 Install nodejs using command prompt
choco install -y nodejs
4 Install the OBDC Driver Microsoft® ODBC Driver 17 for SQL Server
5 Install sqlcmd Microsoft® Command Line Utilities 14.0 for SQL Server
6 Install SSMS Microsoft® Download SQL Server Management Studio
7 Connect to SQL Server using the command prompt
sqlcmd -S localhost -U sa -P your_password