Sql check roles

USE master  
GO  
SELECT DP1.name AS DatabaseRoleName,   
   isnull (DP2.name, 'No members') AS DatabaseUserName   
 FROM sys.database_role_members AS DRM  
 RIGHT OUTER JOIN sys.database_principals AS DP1  
   ON DRM.role_principal_id = DP1.principal_id  
 LEFT OUTER JOIN sys.database_principals AS DP2  
   ON DRM.member_principal_id = DP2.principal_id  
WHERE DP1.type = 'R'
ORDER BY DP1.name;

Similar codes

0 vote230 views1 answer
Php insert null mysql
SQL
5 votes180 views2 answers
Sql number columns
SQL
1 vote169 views1 answer
Woocommerce mysql price table
SQL
0 vote212 views1 answer
How to find unique element in sql
SQL
1 vote161 views1 answer
Xampp import sql file command line
SQL
3 votes173 views3 answers
Into in sql
SQL
12 votes164 views10 answers
Google
SQL
1 vote174 views1 answer
Postgres install unaccent extension
SQL
0 vote141 views1 answer
How to check oracle index table
SQL
0 vote172 views1 answer
UNION ALL LEFT JOIN
SQL