Global Variables@@IDENTITY@@ROWCOUNT@@TRANCOUNTSystem FunctionsAVG()COALESCE(value1, value2, valueN)COUNT(criteria)DATABASEPROPERTYEX(database name, property name)DATEADD(datepart, number to add/subtract, date)DAY(date)DB_ID()DB_NAME(id)GETDATE()GETUTCDATE()LEFT(string, number of characters)LEN(string)LOWER(string)LTRIM(string)MAX()MIN()MONTH(date)OBJECT_NAME(id)RIGHT(string, number of characters)RTRIM(string)SCOPE_IDENTITY()UPPER(string)YEAR(date)System Stored Proceduressp_rename (@objname, @newname, @objtype)sp_help (@objname)