Is it possible to apend the id to the text being inserted.

In ms sql if I have a primary key column of type int and auto increment 1 and another column called text.

When I do an insert is it possible to apend the id to the text being inserted.

ie

Insert in myTable values ('text' + the id of the current rows primary key )

thanks

This topic has been closed for replies.

Inspiring

You must first convert the number to a string. Different db's have different ways of doing that.

You might have to insert the record first and then update it.

Sign up