This T-SQL code demonstrates how to convert line separated text in a SQL Server table into comma separated text using multiple nested REPLACE functions.

​Learn how to search for accented text in SQL Server using the COLLATE function to ignore accents and find all variations of the searched term.

This T-SQL code demonstrates how to use the REPLACE function in Microsoft SQL Server to replace "PO Box" with "P.O. Box" in a string while using a WHERE clause to…

​Learn how to fix the 'String or binary data would be truncated' error when trying to delete a row in SQL Management Studio. Discover the solution to this common issue…

Learn how to convert a datetime column to a formatted date string in SQL using the CONVERT function. Discover different date formats available and their corresponding values.

This SQL query demonstrates how to retrieve the ID of the current year from a lookup table by utilizing the current date with GETDATE(), converting it to a year number…

This article explains how to use a SELECT query to update a value in Microsoft SQL Server 2008. It demonstrates an example where two tables, T_People and T_Artworks, are matched…

Learn how to retrieve the current financial year in SQL with this simple and effective solution, assuming the fiscal year starts on July 1st and ends on June 30th. Get…

​This SQL query demonstrates how to retrieve the current financial year from a lookup table by utilizing the current date, month, year, and cast functions. It returns the selected row…