Danny Ocean (5/2/2013)
Most of people don't know about it because it's not in use in any real scenario. I never use this kind of table in production environment, But i knew it due to someone ask me about it earlier.
Anyway, thanks for question.:-)
A real (especially in old release of sqlserver) scenario is a TALLY table.
INSERT INTO TableA DEFAULT VALUES
Another way to insert values in Table A is:
SET IDENTITY_INSERT TableA ON
INSERT INTO TableA SELECT TOP 10000 ROW_NUMBER() OVER (ORDER BY A.object_id) FROM sys.objects A, sys.objects B
SET IDENTITY_INSERT TableA OFF
I run on tuttopodismo