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.