Sorry if that's not overly clear.
In SQL Server, can I have a field which I can place a string into, and then SQL Server appends an auto-number onto the end?
So for example, say I have column A.
- If I set row 1 in column A to "Foo", the final value will be "Foo1"
- Then if I set row 2 in column A to "Bar", the final value is "Bar2"
Is this possible?