Logically, any key which is allowed to contain non duplicate (unique) values is a unique key,
is a permissible value in SQL Server , so it can have
for a single time
just like any other value.
But as per standards, there is no such rule that only ONE
is allowed. So, with SQL Server you are stuck with just one time