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 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…
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…