Posted by Dan Guzman on 09/01/06 13:08

> 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: Re: Insert Uniqueidentifier after the fact
• Prev in forum: Text Column question
• Thread view: Re: Insert Uniqueidentifier after the fact

[Reply to this message]