Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...

we need to add a new column for the combined values as follows: As you can see, this task combined the size and column value for each record. Now, we want to combine these values into one row for ...