Danny Ocean (5/2/2013)
Most of people don't know about it because it's not in use in any real scenario.
Sure it is, if the table contains other columns, all with defaults.
As a simplistic example:
CREATE TABLE TableA(ID INT IDENTITY (1,1),
LastUpdated datetime default (getdate()))
I don't use this technique often, but have used it in production systems before.