SQL server string, cursor, security and rowset functions
Baya Pavliashvili continues his series on system-supplied functions by discussing the string, security, cursor, and rowset functions. Also discover some extra features, which are not mentioned in the SQL Server online documentation.
One set of security functions helps a database administrator get information about database users and roles. The other set helps us get trace information and is specific to SQL Server Profiler traces (don't ask why they're qualified as security functions because they're used for tracing).
[ Read more ]