SQL Server: CASE Statement
This SQL Server tutorial explains how to use the SQL Server (Transact-SQL) CASE statement with syntax and examples. Description In SQL Server (Transact-SQL), the CASE statement has the functionality of an IF-THEN-ELSE…
SQL Server
This SQL Server tutorial explains how to use the SQL Server (Transact-SQL) CASE statement with syntax and examples. Description In SQL Server (Transact-SQL), the CASE statement has the functionality of an IF-THEN-ELSE…
This SQL Server tutorial explains how to use the TRY_CONVERT function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the TRY_CONVERT function tries to convert an expression…
This SQL Server tutorial explains how to use the CONVERT function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the CONVERT function converts an expression from one…
This SQL Server tutorial explains how to use the TRY_CAST function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the TRY_CAST function tries to convert an expression…
This SQL Server tutorial explains how to use the CAST function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the CAST function converts an expression from one…
This SQL Server tutorial explains how to use the YEAR function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the YEAR function returns a four-digit year (as…
This SQL Server tutorial explains how to use the MONTH function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the MONTH function returns the month (a number…
This SQL Server tutorial explains how to use the GETUTCDATE function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the GETUTCDATE function returns the current UTC date…
This SQL Server tutorial explains how to use the DAY function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the DAY function returns the day of the…
This SQL Server tutorial explains how to use the DATEPART function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the DATEPART function returns a specified part of…