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