Try this:

DECLARE @id varchar(50) = CONVERT(VARCHAR(50), NEWID());

INSERT INTO [yourtable] ( [id]) VALUES (@id);

SELECT @id;