摘要:
use 库名 go declare @tablename nvarchar(100) declare @sql nvarchar(2000) declare @count int declare @a int declare cur_c cursor for select name from sysobjects where xtype='U' and status>=0 open cur_c ... 阅读全文
摘要:
declare @sql varchar(8000) set @sql='' select @sql=@sql+ ', '+name from sysobjects where type= 'V ' and name not in( 'syssegments ', 'sysconstraints ') set @sql= 'drop vie... 阅读全文