批量修改数据库表名
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,@newName
WHILE @@FETCH_STATUS=0
BEGIN
--SET @newName=(replace(@oldname,'YX','PPS'))
print(@oldname+', '+@newName)
--EXEC sp_rename @oldname,@newName
FETCH NEXT FROM cursor_taname INTO @oldname,@newName
END
CLOSE cursor_taname
DEALLOCATE cursor_taname
@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,@newName
WHILE @@FETCH_STATUS=0
BEGIN
--SET @newName=(replace(@oldname,'YX','PPS'))
print(@oldname+', '+@newName)
--EXEC sp_rename @oldname,@newName
FETCH NEXT FROM cursor_taname INTO @oldname,@newName
END
CLOSE cursor_taname
DEALLOCATE cursor_taname