| | | |

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... 阅读全文

posted @ 2009-08-26 16:05 Ducan 阅读(400) 评论(0) 推荐(0)

批量删除存储过程脚本

摘要： --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... 阅读全文

posted @ 2009-08-26 16:03 Ducan 阅读(514) 评论(1) 推荐(0)