代码改变世界

SqlServer中批量修改数据库表名脚本

2013-04-22 09:46 by 樊凯软件, 180 阅读, 0 推荐, 收藏,
摘要：--批量修改数据库表名（sqlserver）declare @oldName varchar(30),@newName varchar(30)declare cursor_taname CURSOR FOR SELECT name,upper(name) as newname FROM sysobjects where type='u'OPEN cursor_taname FETCH NEXT FROM cursor_taname INTO @oldname,@newNameWHILE @@FETCH_STATUS=0 BEGIN p... 阅读全文