add new column with guid not null in sql

--add new column with guid not null


ALTER TABLE [dbo].CustomContent ADD CustomContentGuid uniqueidentifier NOT NULL Default NewID()