I do that. Sample you has a "name" field. first you fill "name" field with unique random data (sample you can use guid for that). update that. and find record with that unique name field. so you will have identity column. after that you fill your name field with normal data. I use this way in some situations.