Software 101 – Database Part 2

Software User information by UserID

1. Open up SQLQuery

2. Execute query to look up a software user by email address or fist and last name to locate their UserID

exec [Support].[User_Info_ByEmail] ’email address’

Select *
from [User]
where LastName = ‘LastName’ and FirstName = ‘FirstName’

3. Locate the UserID

4. Place that UserID into the following query

select *
from [User]
where UserId = ‘600969’

This query provides you will all the information pertaining to this user.

Test your skills

When ready click the ‘Start Quiz’ button below to test your skills in the database.

Copy link