• You could do this with some type of variable, but I would recommend using IDENTITY for an incremental ID column.