How to set up TSQL in Vscode with Northwind2022 using SQLNotebook

Viewed 14

Hey guys I've been assigned to use TSQL and I'm using vscode. As a beginner on this TSQL journey, I couldn't really find a specific video on youtube to help me get started on setting this up. I currently have Jupiter notebook set up and it does provide support for SQL language however I'm pretty certain that's not the way to go for me.

I downloaded a mySqlNotebook extension and I'm guessing this is the starting point. Ive created a connection with the following information...

Dispaly Name: Oliver host: localhost port: 3000 user: acera database: Oliver driver: mssql

and I get an error message when I try to connect to it as follows: Failed to connect to "Oliver": Failed to connect to localhost:3000 - Could not connect (sequence)

My main question is what do I need to get going, what are the pieces of information that I'm missing? Would really appreciate the answer guys thanks.

as for the Northwind2022 I've found this link

https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd.sql

0 Answers
Related