| 
	
 | 
 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] 
 |