how to get SQL to show all users code example

Example: sql server get users

select * from master.sys.server_principals