2009年8月26日

摘要： select ID_Num = IDENTITY(int, 1, 1),name into #tempt from sysobjects where xtype = 'U' and name like 'ESC_%' and status >=0select * from #temptdeclare @id intset @id = 1DECLARE @STRING VARCHAR(8000... 阅读全文

摘要： --sql2000DECLARE @STRING VARCHAR(8000)WHILE EXISTS(SELECT * FROM SYSOBJECTS WHERE xtype = 'p' and name like 'PRC%'AND status >=0 AND name <> 'PRC_TASK_LIST_SELALL')BEGINSELECT @STRING='DROP P... 阅读全文