Concatinated default value from sequence on a non primary key column...

SQL Server get multiple next values for sequence...

Getting the sequenced id of a row to be the foreign key of a row in another table in one query...

Is it possible to concatenate a string to a sequence value and use as a column default value?...