游标自动执行，批量处理数据库中的所有表

最新推荐文章于 2018-09-03 10:02:12 发布

小马本色

最新推荐文章于 2018-09-03 10:02:12 发布

阅读量570

点赞数

分类专栏： SQL数据库

本文链接：https://blog.csdn.net/kejia90/article/details/19610101

版权

SQL数据库专栏收录该内容

5 篇文章 0 订阅

订阅专栏

use CNtitleCollectionDB;
declare @tbName varchar(30)
declare Curb cursor for
select name from sys.tables
open Curb
fetch next from Curb into @tbName
while @@fetch_status=0
begin

exec('update '+ @tbName+' set CNtitle = rtrim(ltrim(CNtitle)) where Unicode(ltrim(CNtitle)) = ASCII(ltrim(CNtitle))')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''-%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''@%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''#%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''&%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''$%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''：%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''.%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''/%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''*%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''？%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''！%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''''''%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（1）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（2）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（3）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（4）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（5）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（6）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（7）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（8）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（9）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''（0）%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''（：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,2,len(CNtitle)-1) WHERE CNtitle like '+'''，%'''+' AND len(CNtitle)>2')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''1？%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''1。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''2。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''3。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''4。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''5。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''6。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''7。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''8。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''9。%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''10。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''11。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''12。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''13。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''14。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''15。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''16。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''17。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''18。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''19。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''20。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''21。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''22。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''23。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''24。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''25。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''26。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''27。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''28。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''29。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''30。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''31。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''32。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''33。%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''1：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''2：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''3：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''4：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''5：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''6：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''7：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''8：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,3,len(CNtitle)-2) WHERE CNtitle like '+'''9：%'''+' AND len(CNtitle)>3')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''10：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''11：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''12：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''13：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''14：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''15：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''16：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''17：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''18：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''19：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''20：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''21：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''22：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''23：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''24：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''25：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''26：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''27：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''28：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''29：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''30：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''31：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''32：%'''+' AND len(CNtitle)>4')
exec('update '+ @tbName+' set CNtitle = substring(CNtitle,4,len(CNtitle)-3) WHERE CNtitle like '+'''33：%'''+' AND len(CNtitle)>4')

fetch next from Curb into @tbName
end
close Curb
deallocate Curb