SQL Server

This SQL Server tutorial explains how to use the SESSIONPROPERTY function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the SESSIONPROPERTY function returns the setting for a…

This SQL Server tutorial explains how to use the NULLIF function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the NULLIF function compares expression1 and expression2. If expression1 and expression2 are equal, the NULLIF function…

This SQL Server tutorial explains how to use the ISNUMERIC function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the ISNUMERIC function returns 1 if the expression is a…

This SQL Server tutorial explains how to use the ISNULL function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the ISNULL function lets you return an alternative…

This SQL Server tutorial explains how to use the ISDATE function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the ISDATE function returns 1 if the expression is a…

This SQL Server tutorial explains how to use the SYSTEM_USER function in SQL Servers (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the SYSTEM_USER functions returns the login name information…

This SQL Server tutorial explains how to use the SESSION_USER function in SQL Servers (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the SESSION_USER function returns the user name of…

This SQL Server tutorial explains how to use the USER_NAME function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the USER_NAME function returns the user name in…

This SQL Server tutorial explains how to use the CURRENT_USER function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the CURRENT_USER functions returns the name of the…

This SQL Server tutorial explains how to use the COALESCE function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the COALESCE functions returns the first non-null expression…