SQL – How to copy column data to another column
Learn how to copy column data to another column using SQL with this helpful article and example code snippet. Perfect for database administrators looking to update or migrate their data…
SQL
SQL – How to convert line separated text to comma separated
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.
SQL – How to search with accented characters
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.
SQL -Find and replace text in string
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…
SQL Management Studio – unable to delete row ‘String or binary data would be truncated’
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…
SQL – How to convert datetime to formatted date string dd-mm-yyyy
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.
SQL – How to select current year from lookup table
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…
MS SQL Server 2008 – How to update value using SELECT results
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…
SQL – How to get current financial year using SQL
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…