摘要： 先把第一句话放到sqlserver查询器中执行一下.然后把查询结果复制出来,进行编辑...一看你就懂了..简单的sql语句拼装select ' exec sp_rename "' + name + '","new'+ name +'","object" ' from sysobjects where... 阅读全文