declare @a varchar(8000)
set @a=''
select @a=@a+','+a.name from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and b.name='char' and d.name='recordnumber1表'
set @a=right(@a,len(@a)-1)exec('select '+@a+' from recordnumber1表')
set @a=''
select @a=@a+','+a.name from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and b.name='char' and d.name='recordnumber1表'
set @a=right(@a,len(@a)-1)exec('select '+@a+' from recordnumber1表')
set @a=''
select @a=@a+','+a.name from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and b.name='char' and d.name='recordnumber1表'
set @a=right(@a,len(@a)-1)exec('select '+@a+' from recordnumber1表')
选中Microsoft SQL Servers-->工具栏,工具-->选项-->高级-->查询超时-->改为0选中Microsoft SQL Servers-->工具栏,工具-->选项-->高级-->连接超时-->改为0
ADONonnectionTimeout 连接时间长一点;
CommandTimeout 执行时间长一点!问题二:
SQL SERVER企业管理器-->右键你的表-->设计表-->选中你要设置标识的字段(必须是int或其他数字类型)-->下面有个属性叫“标识”的,选“是”,你可以按你的要求改一下标识种子或标识递增量,然后保存该表的设计。