Posted by pltaylor3 on 09/01/06 13:11

Thats perfect. Thanks for the help.
Dan Guzman wrote:
> > What sql script could I run to actually place a value for
> > the newly created column for each record?
>
> You can use NEWID() to backfill existing data:
>
> UPDATE dbo.MyTable
> SET MyColumn = NEWID()
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> <pltaylor3@gmail.com> wrote in message
> news:1157114291.688642.258140@b28g2000cwb.googlegroups.com...
> >I have an existing table that i would like to add a uniquidentifier to
> > each record of the table. I have already create a column for the
> > uniqueid. What sql script could I run to actually place a value for
> > the newly created column for each record?
> > thanks for your help ahead of time
> >

• Next in forum: Column order/presentation in virtual table (result set from view or UDF)
• Prev in forum: Re: Insert Uniqueidentifier after the fact
• Thread view: Re: Insert Uniqueidentifier after the fact

[Reply to this message]