-- 下面的测试可以说明问题.USE tempdb GOSELECT a = CAST(NULL as int) INTO tb FROM syscolumns a, syscolumns b EXEC sp_spaceused 'tb' DROP TABLE tb GOSELECT a = CAST(NULL as varchar(8000)) INTO tb FROM syscolumns a, syscolumns b EXEC sp_spaceused 'tb' DROP TABLE tb GOSELECT TOP 1024 a = CAST(NULL as char(1024)) INTO tb FROM syscolumns a, syscolumns b EXEC sp_spaceused 'tb' DROP TABLE tb GOSELECT a = CAST(NULL as binary(2)) INTO tb FROM syscolumns a, syscolumns b EXEC sp_spaceused 'tb' DROP TABLE tb
GOSELECT a = CAST(NULL as int) INTO tb FROM syscolumns a, syscolumns b
EXEC sp_spaceused 'tb'
DROP TABLE tb
GOSELECT a = CAST(NULL as varchar(8000)) INTO tb FROM syscolumns a, syscolumns b
EXEC sp_spaceused 'tb'
DROP TABLE tb
GOSELECT TOP 1024 a = CAST(NULL as char(1024)) INTO tb FROM syscolumns a, syscolumns b
EXEC sp_spaceused 'tb'
DROP TABLE tb
GOSELECT a = CAST(NULL as binary(2)) INTO tb FROM syscolumns a, syscolumns b
EXEC sp_spaceused 'tb'
DROP TABLE tb
http://chinadba.cn
深圳骄子数据库服务网
最具实战经验的数据库优化、管理、设计、培训。
^^^老老实实做人,勤勤恳恳做事^^^