Hello. I am taking a Database Administration Course and I am not understanding t
ID: 3902743 • Letter: H
Question
Hello. I am taking a Database Administration Course and I am not understanding the following questions or how to code this correctly in SQL: Your assistance would be greatly appreciated.
Query the catalog view sys.server_principals to return only the data for module4Login 4. Add a WHERE clause to modify the following query to return only the data for module4Login and execute the query 5. SELECT p. NAME as roleName, m. NAME as principalName FROM sys.server_role_members rm INNER JOIN sys.server_principals p ON rm.role_principal_id -p.principal_id INNER JOIN sys.server_principals m ON rm.member_principal_id - m.principal_idExplanation / Answer
4. SELECT * FROM sys.server_principals
WHERE module4Login='<your initials here>';
5. SELECT p.name as roleName, m.Name as principalName
FROM sys.server_role_members rm
INNER JOIM sys.server_principals p ON
rm.role_principal_id = p.principal_id
INNER JOIN sys.server_principals m ON rm.member_principal_id = m.principal_id
WHERE module4Login='<your initials here>';
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.