You are working as a System Administrator and have been tasked with querying a running MSSQL instance. You are to query the database for the name of the user with an *ID* of **3**, and the *ID* of the user with the name **David**.
The password for the `SA` database user is the same as the `cloud_user` password, with **+2020** appended. For your convience, this password has been saved in `/home/cloud_user/database_passwd.txt`
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Connect to the Database
Connect to the
demo
database, as theSA
user, on the SQL server running onlocalhost
:/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';