Is there any way to add default to the column with function call
like this one ?

create table xyz
Adv_ID int PRIMARY KEY DEFAULT fn_GetNextID('ETADVANCEADVID')

Thanks
Sonali