SQL Server - Unique Constraint Syntax
Tested - see picture below (renamed table in the second example to test_uq_2)

Not much difference really, but - in my opinion, second example is better, because it gives you the ability to name the constraint/index, while in the first example SQL Server names it automatically