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
WordPress – How to protect your database queries using prepared statements
Learn how to protect your WordPress database queries using prepared statements with our step-by-step guide. Discover how to create prepared database queries, understand how prepared statements work and what types…
T-SQL – How to reset auto increment to next available number
This T-SQL code will show you how to reset an auto incremented column in SQL Server, specifically when you need to start from the next available number after removing large…
T-SQL – How to reset auto increment to 1
This T-SQL code snippet demonstrates how to reset an identity column's auto-increment value back to 1 in SQL Server. It should only be used when the table is empty, as…
T-SQL – How to output day name from date
This T-SQL code demonstrates how to retrieve the day name from a given date using the DATENAME function in SQL Server.
T-SQL – How to output day number from date
Learn how to extract the day number from a date using T-SQL with this simple and effective code snippet. Get the day number for any given date in 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.
T-SQL – How to output ordinal number – 1ST 2ND 3RD 4TH
This T-SQL code demonstrates how to output numbers as ordinal numbers using CASE statements in SQL Server. Learn how to replace a number with a field and format it correctly…
T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH
This T-SQL statement demonstrates how to output the day from a date in ordinal numbers using SQL Server. Learn how to replace `Getdate()` with your date field and format the…