This will give you the current database user's name. If you're using windows login, it will be the name of the current windows user. If you're using database login, it will be the name of the db user that logged into the database.
SELECT CURRENT_USER;