SQL – Query to find tables with column name
Find Tables with Column Name using SQL - Learn how to use this simple SQL query to identify tables containing a specific named column, like Gender, in your database. Supported…
SQL Server
T-SQL – How to output name of month
This T-SQL code demonstrates how to display the name of the current month using the DATENAME function in SQL Server.
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.
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…