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