Trigger Help 1

[nathanharcup]

Hi All,
I am having an issue at the moment where I need to generate a random guid (uniqueidentifier) within a table when a row is inserted.

I am after some clarity that the quickest way to atchive this would be to drop the column and re-add it using;

CREATE TABLE MyUniqueTable
(UniqueColumn UNIQUEIDENTIFIER DEFAULT NEWID(),
Characters VARCHAR(10) )
GO

would the insert statment need to use newid() ?

Is there a way I can implement a trigger after insert to generate this value (if it has not already been generated)?

Thanks
Nathan

 

[JayKusch]

Why would you not open the table in design mode and set that particular columns DEFAULT to be NEWID(). That way when the record is inserted, the new GUID is created and populates the field?

Thanks

J. Kusch

 

[nathanharcup]

Thanks I didn't realise it was as easy as that