SQL STRING_AGG Function Use and Examples
The post SQL STRING_AGG Function Use and Examples appeared first on SQLServerCentral.
t-sql
SQL ASCII Function Use and Examples
The post SQL ASCII Function Use and Examples appeared first on SQLServerCentral.
Evaluating the Randomness of SQL Server Random Number Functions
The post Evaluating the Randomness of SQL Server Random Number Functions appeared first on SQLServerCentral.
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and ...
Working with dates in SQL Server is something almost every developer runs into. You might need to figure […]
SQL Server Cursor Example
The post SQL Server Cursor Example appeared first on SQLServerCentral.
Understanding MERGE to Insert, Update, and Delete Data Simultaneously
Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]
Return stored procedure parameter values to a calling stored procedure
The post Return stored procedure parameter values to a calling stored procedure appeared first on SQLServerCentral.
Purging Data from a Large Table in SQL Server
Purging data from a table is a common database maintenance task to prevent it from growing too […]
Using the CASE expression instead of dynamic SQL in SQL ...
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]
The Subtle Differences Between COALESCE and ISNULL
If you’ve written SQL for a while, you’ve likely bumped into COALESCE and ISNULL. Both are handy for […]
Creating a Date Dimension (Calendar Table) in SQL Server
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]
Elements of the SQL Server Update Statement
Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update […]
Understanding UNION and UNION ALL in SQL Server
Have you ever needed to combine data from two different tables or queries in SQL Server? Maybe you’ve […]
Basic Regex Emulator for SQL Server
The post Basic Regex Emulator for SQL Server appeared first on SQLServerCentral.
Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
In February 2025, Microsoft introduced new T-SQL functions in Azure SQL Database and SQL Database in Microsoft Fabric […]
Improving the Performance of UPDATE Statements in SQL Server
Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. […]
T-SQL Has Regex. Don’t Get Too Excited.
Regular expressions are a way of doing complex string searches. They can be really useful, but they have […]
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]
How to Download and Restore AdventureWorks 2019 Database
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
Understanding the Logical Functions IIF and Choose in SQL Server ...
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting […]
The Power of Generate_series
The post The Power of Generate_series appeared first on SQLServerCentral.
Determining Whether Home Addresses Fall Within a Tornado Polygon Using ...
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the […]
How to Download and Restore AdventureWorks 2022 Database
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL ...
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These […]
Find Text in Stored Procedure, Function, View, or Trigger
The post Find Text in Stored Procedure, Function, View, or Trigger appeared first on SQLServerCentral.
Understanding Data Type Conversion Functions in SQL Server with PARSE, ...
Introduction SQL Server provides robust tools for data type conversion, such as PARSE, TRY_PARSE, and TRY_CONVERT. These functions […]
How to use @@ROWCOUNT in SQL Server
The post How to use @@ROWCOUNT in SQL Server appeared first on SQLServerCentral.
Add and Subtract Dates using DATEADD in SQL Server
The post Add and Subtract Dates using DATEADD in SQL Server appeared first on SQLServerCentral.
Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE
Introduction Attaching databases in SQL Server can be a routine yet sometimes time-consuming task for Database Administrators (DBAs). […]
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions ...
Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls […]
Resolving Access Denied Errors During SQL Server Database Attachment
Introduction Database administrators regularly detach and attach databases as part of their daily tasks. During this process, they […]
SQL Server OPTION RECOMPILE for Simple Queries
The post SQL Server OPTION RECOMPILE for Simple Queries appeared first on SQLServerCentral.
How to Attach and Detach Databases in SQL Server
Introduction Managing databases in SQL Server requires a solid understanding of various methods for transferring and maintaining data. […]
Attaching an SQL Server database without Transaction Log Files through ...
Introduction In SQL Server, the transaction log file is essential for keeping your database reliable and durable. It […]
Why a Self-Join Requires Halloween Protection
The post Why a Self-Join Requires Halloween Protection appeared first on SQLServerCentral.
Calculate a Moving Average with T-SQL Windowing Functions
The post Calculate a Moving Average with T-SQL Windowing Functions appeared first on SQLServerCentral.
SQL IS NULL and SQL IS NOT NULL Examples
The post SQL IS NULL and SQL IS NOT NULL Examples appeared first on SQLServerCentral.
How to Develop Custom T-SQL Code Snippets in Azure Data ...
To get started, follow these steps to find and use the default snippets in Azure Data Studio. In […]
Optimize SQL LIKE Wildcard Searches
The post Optimize SQL LIKE Wildcard Searches appeared first on SQLServerCentral.
T-SQL Notebooks: Manage Views Source Control and more
T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss […]
Troubleshoot Chained SQL Server CTE
The post Troubleshoot Chained SQL Server CTE appeared first on SQLServerCentral.
Should That Be One Update Statement or Multiple?
Let’s say we have a couple of update statements we need to run every 15 minutes in the […]
Converting Old Running Total Code to Window Functions
I ran across an article that showed calculating a running total with a twist. In this case, the […]
TRY/CATCH Doesn’t Always Work.
If you’re using TRY/CATCH to do exception handling in T-SQL, you need to be aware that there are […]
SQL ROUND Function vs. Bankers Rounding with T-SQL
The post SQL ROUND Function vs. Bankers Rounding with T-SQL appeared first on SQLServerCentral.
Express a Number or Currency in Words with T-SQL Code
The post Express a Number or Currency in Words with T-SQL Code appeared first on SQLServerCentral.
Create Document Templates in a SQL Server Database Table
The post Create Document Templates in a SQL Server Database Table appeared first on SQLServerCentral.
The SQL Language is Just a Hurdle You Gotta Overcome.
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and […]
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads […]