You are here: Re: Combining INTO with UNION « MsSQL Server « IT news, forums, messages
Re: Combining INTO with UNION

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация