- Make sure have Docker & node (NPM) installed.
-
npm install -
docker-compose up -d -
docker-compose psto watch that image. -
docker exec -it sql-server-db "bash" -
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P docker_msql_password -
create database testdb> nd thengo -
use testdb> ndgo. -
create table users (id INT , name VARCHAR(120), email NVARCHAR(255))> nd thengo -
insert into users values(1, 'Kun Maradona', 'kun.maradona@afa.com.ar') > nd >
go
select * from users nd go
nd then exit...
-node index.js
🥳 Enjoy 👍🏼