摘要：---循环declare @n intdeclare @rowcount int declare @name varchar(50)create table #temp( id int identity(1,1), ColumnNme nvarchar(100))insert into #temp ...
阅读全文
摘要：--SQL Server 2005, 2008 or 2012:SELECT * FROM information_schema.tables--SQL Server 2000:SELECT * FROM sysobjects WHERE xtype='U' SELECT * FROM sysobj...
阅读全文
