MSSQL adding Column (Alter Table) where default calculate days between NOW and other Column

Job ID: 33952143

Budget: €8 – €30 EUR

Hi,
MSSQL adding Column (Alter Table) where default calculate days between NOW and other Column

I want to add Column with name "Dopen" where there is a default calculation between NOW an field "besteldatum" (in same Table)

This is a urgent task.

Thanks in advance.