SQL Concat Operator and UNISTR Function in Azure
Explore the concat operator in T-SQL and UNISTR function for handling Unicode characters and managing strings in Azure SQL DB.
Functions System
Check out these valuable tips, tutorials, how-to’s, scripts, and more on SQL Server Functions – System perfect for SQL Server Developers.
New SQL Regex Functions in SQL Server 2025 and SSMS
In this article, we cover the new SQL regex functions built into SQL Server 2025 and how these can be used in your SQL code.
Evaluating the Randomness of SQL Server Random Number Functions
In this tips, we look at how randomness of values for the SQL Server random number functions rand, newid, and crypt_gen_random.
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG
In this article, we learn about two new SQL Server functions to work with JSON data JSON_OBJECTAGG and JSON_ARRAYAGG.
Convert a String to JSON with SQL Server Queries
In this article, we look at various ways to generate JSON formatted data for SQL Server queries using FOR JSON option.
SQL Convert Examples for Dates, Integers, Strings and more
In this article, we look at how to use the SQL CONVERT function to convert between data types such as date, integers, strings, and more.
NTILE SQL Function to Group and Rank Datasets
Learn how to use the NTILE SQL function to group and rank datasets along with practical examples.
SQL Server JSON_PATH_EXISTS Function
Learn how to use the new JSON_PATH_EXISTS function to determine if a specific path in a JSON document exists.
SQL Server ISJSON for valid Value, Array or Object JSON format
Learn about an enhancement to the ISJOSN function that allows you to validate whether the JSON format is valid for a value, array, or object.
SQL SUM Function for Aggregating and Summarizing Totals
In this article, we look at different examples of using SUM when aggregating and summarizing totals when working with SQL Server data.
SQL Server ROW_NUMBER Ranking Function that Returns a Row Rank Value
This article covers how to use SQL Server ROW_NUMBER() which is a ranking function that returns a rank value for each row in a group or groups.
SQL COUNT DISTINCT and SQL COUNT Examples in SQL Server
This tip shows several examples of COUNT and COUNT DISTINCT to show how SQL Server handles them differently.
SELECT COUNT FROM SQL Server Examples and Statistics
Learn about the impact of using COUNT in your SQL Server queries along with several examples and statistics of how using COUNT impacts performance.
SQL Server Logarithmic Functions LOG() and LOG10() for Data Outliers
In this article, we look at how to use the SQL Server system functions, LOG and LOG10, to get logarithmic data values to be used for data analysis.
SQL Server OBJECTPROPERTY Function Examples
SQL Server objects have many different property attributes learn how to use the OBJECTPROPERTY() system function to return various data about objects.
SQL CONVERT, CAST, TRY_CAST, TRY_CONVERT and TRY_PARSE Examples
In this article, we look at various ways to convert problematic data in SQL Server by using TRY_CAST, TRY_CONVERT, and TRY_PARSE.
Metadata Functions in SQL Server SERVERPROPERTY, DB_NAME, OBJECT_ID
Learn about SQL Server metadata functions like SERVERPROPERTY, DATABASEPROPERTYEX, DB_NAME, DB_ID, FILE_NAME, FILE_ID, FILE_IDEX, SCHEMA_NAME and more
SQL Concatenate Strings Example
Learn how to concatenate data in SQL Server to make one long string instead of having separate columns.
Delay SQL Code Execution with SQL WAITFOR
In this article, we look at the SQL Server WAITFOR command to allow delays in processing either for a specified time or a set amount of time.
SQL COUNT and SQL COUNT_BIG Functions
In this article, we look at how to get a count of rows from SQL Server using the COUNT and COUNT_BIG aggregate functions along with several examples.
SQL Server Configuration Functions
Learn about SQL Server configuration functions to return information about SQL Server, sessions, configuration settings and more.
SQL Average Function to Calculate Average of a set of SQL Server Rows
Learn various ways to calculate the average of a set of SQL Server rows using the AVG function along with several use cases and examples.
SQL Convert INT to String
In this article we cover different ways to convert a SQL Server numeric value into a string value.
SQL PIVOT and SQL UNPIVOT Examples to Transform Data
In this article learn how to use PIVOT and UNPIVOT in SQL Server to transform your data output along with examples.