|
Posted by MC on 11/22/05 16:41
well, you can add identity column after you insert data. So, after insert
issue:
go
alter table table1
add Something_ID int identity(1,1)
LMK if you need anything else
MC
"Andy Kent" <andykent.bristol1095@virgin.net> wrote in message
news:1132669133.662008.221370@z14g2000cwz.googlegroups.com...
> Thanks, that worked...
>
> Next part of problem: how would I get it to create and populate an
> IDENTITY column?
>
> Bearing in mind I'm working in DTS, which doesn't like anything too
> clever ...
>
Navigation:
[Reply to this message]
|