摘要:
修改:declare proccur cursor for select [name] from sysobjects where name like 'Foods_%'declare @procname varchar(100)declare @temp varchar(100)open proccurfetch next from proccur into @procnamewhile(@@FETCH_STATUS = 0)begin set @temp='kcb_'+@procname EXEC SP_RENAME @procname,@temp prin 阅读全文