How to update an existing table with a new uniqueidentifier column?

[xavstone]

Hi All,

I have added a uniqueidentifier column to an existing table in Microsoft SQL Server.

All I want to do is populate the existing records with new Guids. I have tried things based on this to no avail:

@GUID uniqueidentifier

AS

UPDATE sysx_groups SET GUID=@GUID

	RETURN

Any help much appreciated.

Ben

 

[bborissov]

UPDATE sysx_groups SET GUID=NewId()

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[xavstone]

ah! *Slaps forehead*

Thank you very much

Ben