Thursday, August 30, 2018

SUSER_NAME() and SUSER_SNAME() in T-SQL

Both give you the user name and this suggests that SUSER_SNAME() uses the security identification number (SID) string, whatever that is, while SUSER_NAME() uses principal_id, an integer, to calculate the name it returns to you.

No comments:

Post a Comment