Connect to This SQL Server Database on Linux

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Connect to the Database

Connect to the demo database, as the SA user, on the SQL server running on localhost:

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -d demo

Print the Name of the User with an ID of 3

select name from users where ID = 3;

Print the ID of the User Named David

The data types text and varchar are incompatible with the equal to operator:

select ID from users where name LIKE 'David';