declare cursor1 cursor for select d.name,a.name from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and b.name like '%char'
declare @i varchar(100),@j varchar(100),@f varchar(100)
open cursor1
fetch cursor1 into @i,@j
while @@fetch_status=0
begin
set @f='加州'+right(@j,len(@j)-2)
exec('update '+@i+' set '+@j+'=''加州''+right('+@j+',len('+@j+')-2) where '+@j+' like ''山东0531%''')
fetch cursor1 into @i,@j
end
close cursor1
deallocate cursor1
declare cursor1 cursor for select d.name,a.name from syscolumns a,sysobjects d where a.id=d.id and d.xtype='U' and a.name like '山东0531%'
declare @i varchar(100),@j varchar(100),@f varchar(100)
open cursor1
fetch cursor1 into @i,@j
while @@fetch_status=0
begin
set @f='加州'+right(@j,len(@j)-2)
exec('sp_rename '''+@i+'.'+@j+''','''+@f+'''')
fetch cursor1 into @i,@j
end
close cursor1
deallocate cursor1
declare cursor_insert cursor for select c# from cs
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
declare @s varchar(20)
set @s=''
declare cur_a cursor for select a.name from sysobjects a,syscolumns b where a.id=b.id and b.name like'山东0531%'
open cur_a
fetch next from cur_a into @s
while @@fetch_status<>0
begin
exec('sp_rename '+@s+','+replace(@s,'山东','加州')+',''COLUMN''')
fetch next from cur_a into @s
end
close cur_a
deallocate cur_a
declare @s varchar(20)
set @s=''
declare cur_a cursor for select a.name from sysobjects a,syscolumns b where a.id=b.id and b.name like'山东0531%'
open a
fetch next from cur_a into @s
while @@fetch_status<>0
begin
exec('sp_rename '+@s+','+replace(@s,'山东','加州')+',''COLUMN''')
fetch next from cur_a into @s
end
close cur_a
deallocate cur_a
declare cursor1 cursor for select d.name,a.name from syscolumns a,sysobjects d where a.id=d.id and d.xtype='U' and a.name like '山东0531%'
declare @i varchar(100),@j varchar(100),@f varchar(100)
open cursor1
fetch cursor1 into @i,@j
while @@fetch_status=0
begin
set @f='加州'+right(@j,len(@j)-2)
print('sp_rename '''+@i+'.'+@j+''','''+@f+'''')
fetch cursor1 into @i,@j
end
close cursor1
deallocate cursor1