摘要: Select Distinct sysobj.name From dbo.sysobjects sysobj Inner Join dbo.syscolumns syscol On sysobj.id=syscol.id where sysobj.xtype='U' and COLUMNPROPERTY(syscol.id,syscol.name,'IsIdentity')=1 阅读全文
posted @ 2009-06-25 16:35 空紫竹 阅读(169) 评论(0) 推荐(0) 编辑
摘要: Declare @iCount int,@familyTableName varchar(50),@Sql varchar(3000) Declare @tempTable Table(familyTableName varchar(50) primary key(familyTableName)) Insert @tempTable(familyTableName) Select Dist... 阅读全文
posted @ 2009-06-25 16:32 空紫竹 阅读(222) 评论(0) 推荐(0) 编辑