DROP TABLE T GO SELECT TOP 1000 C1=IDENTITY(INT,1,1) INTO T FROM SYSOBJECTES,SYSCOLUMNS GO
Using Cross Joins A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. This is an example of a Transact-SQL cross join
With an identity column only??
--------------------
是啊
GO
SELECT TOP 1000 C1=IDENTITY(INT,1,1) INTO T
FROM SYSOBJECTES,SYSCOLUMNS
GO
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. This is an example of a Transact-SQL cross join