The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type 'uniqueidentifier' ...

The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type 'uniqueidentifier' in a CREATE TABLE or ALTER TABLE statement. It cannot be combined with other operators to form a complex scalar expression.