• SQL Functions Mapping to Other Databases
• Numeric Functions
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATN2
  • CEILING
  • COS
  • COT
  • DEGREES
  • EXP
  • FLOOR
  • LOG
  • LOG10
  • PI
  • POWER
  • RADIANS
  • RAND
  • ROUND
  • SIGN
  • SIN
  • SQRT
  • SQUARE
  • TAN
• String Functions
  • ASCII
  • CHAR
  • CHARINDEX
  • DIFFERENCE
  • LEFT
  • LEN
  • LOWER
  • LTRIM
  • NCHAR
  • PATINDEX
  • QUOTENAME
  • REPLACE
  • REPLICATE
  • REVERSE
  • RIGHT
  • RTRIM
  • SOUNDEX
  • SPACE
  • STUFF
  • SUBSTRING
  • UNICODE
  • UPPER
• Date and Time Functions
  • CURRENT_TIMESTAMP
  • DATEADD
  • DATEDIFF
  • DATENAME
  • DATEPART
  • DAY
  • GETDATE
  • GETUTCDATE
  • ISDATE
  • MONTH
  • SET DATEFIRST
  • SET DATEFORMAT
  • SET LANGUAGE
  • sp_helplanguage
  • SWITCHOFFSET
  • SYSDATETIME
  • SYSDATETIMEOFFSET
  • SYSUTCDATETIME
  • TODATETIMEOFFSET
  • YEAR
• Analitic and Aggregate Functions
  • AVG
  • CHECKSUM_AGG
  • COUNT
  • COUNT_BIG
  • DENSE_RANK
  • GROUPING
  • MAX
  • MIN
  • NTILE
  • RANK
  • ROW_NUMBER
  • STDEV
  • STDEVP
  • SUM
  • VAR
  • VARP
• Conversion Functions
  • CAST
  • CONVERT
  • STR
• XML Functions
  • OPENXML
• Environment and System Functions
  • APP_NAME
  • ASSEMBLYPROPERTY
  • COALESCE
  • COL_LENGTH
  • COL_NAME
  • COLLATIONPROPERTY
  • COLUMNPROPERTY
  • COLUMNS_UPDATED
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • CURRENT_USER
  • DATABASEPROPERTY
  • DATABASEPROPERTYEX
  • DATALENGTH
  • DB_ID
  • DB_NAME
  • ERROR_LINE
  • ERROR_MESSAGE
  • ERROR_NUMBER
  • ERROR_PROCEDURE
  • ERROR_SEVERITY
  • ERROR_STATE
  • FILE_ID
  • FILE_IDEX
  • FILE_NAME
  • FILEGROUP_ID
  • FILEGROUP_NAME
  • FILEGROUPPROPERTY
  • FILEPROPERTY
  • fn_helpcollations
  • fn_listextendedproperty
  • fn_servershareddrives
  • fn_virtualfilestats
  • fn_virtualfilestats
  • FORMATMESSAGE
  • FULLTEXTCATALOGPROPERTY
  • FULLTEXTSERVICEPROPERTY
  • GETANSINULL
  • Has_Perms_By_Name
  • HOST_ID
  • HOST_NAME
  • IDENT_CURRENT
  • IDENT_INCR
  • IDENT_SEED
  • IDENTITY
  • INDEX_COL
  • INDEXKEY_PROPERTY
  • INDEXPROPERTY
  • IS_MEMBER
  • IS_SRVROLEMEMBER
  • ISDATE
  • ISNULL
  • ISNUMERIC
  • NEWID
  • NULLIF
  • OBJECT_ID
  • OBJECT_NAME
  • OBJECTPROPERTY
  • OBJECTPROPERTYEX
  • ORIGINAL_LOGIN
  • PARSENAME
  • PERMISSIONS
  • ROWCOUNT_BIG
  • SCHEMA_ID
  • SCHEMA_ID
  • SCHEMA_NAME
  • SCHEMA_NAME
  • SCOPE_IDENTITY
  • SERVERPROPERTY
  • SESSION_USER
  • SESSION_USER
  • SESSIONPROPERTY
  • SETUSER
  • SQL_VARIANT_PROPERTY
  • STATS_DATE
  • SUSER_ID
  • SUSER_NAME
  • SUSER_SID
  • SUSER_SNAME
  • sys.dm_db_index_physical_stats
  • sys.fn_builtin_permissions
  • SYSTEM_USER
  • SYSTEM_USER
  • TYPE_ID
  • TYPE_NAME
  • TYPEPROPERTY
  • UPDATE
  • USER_ID
  • USER_NAME
  • USER_NAME
  • XACT_STATE
• Other Functions
  • CONTAINSTABLE
  • CURSOR_STATUS
  • FREETEXTTABLE
  • OPENDATASOURCE
  • OPENQUERY
  • OPENROWSET
  • PATINDEX
  • TEXTPTR
  • TEXTVALID

SQLWays Product Page - Migration to SQL Server Free Evaluation