34,593
社区成员
发帖
与我相关
我的任务
分享
declare @current_tablename varchar(256)
exec('declare my_cursor1 cursor for select distinct tablename from A')
open my_cursor1
declare @tablename sysname
fetch next from my_cursor1 into @tablename
while(@@fetch_status= 0)
begin
set @current_tablename =convert(varchar(256),@tablename)
fetch next from my_cursor1 into @tablename
end
close my_cursor1
deallocate my_cursor1
update test set code=SUBSTRING(code,1,1)+'1'+SUBSTRING(code,2,len(code))
create table test(code nvarchar(10))
insert into test values('11110')
insert into test values('12110')
insert into test values('13110')
insert into test values('14110')
insert into test values('15110')
update test set code=SUBSTRING(code,1,1)+'1'+SUBSTRING(code,2,len(code))
/*
111110
112110
113110
114110
115110
*/
declare @index int
declare @tablename varchar(256)
set @index = 1
while @index<=100
begin
set @tablename = 'A'+@index
--写访问表和插入数据的代码
set @index= @index+1
end
create table test(code nvarchar(10))
insert into test values('11110')
insert into test values('12110')
insert into test values('13110')
insert into test values('14110')
insert into test values('15110')
update test set code=SUBSTRING(code,1,1)+'1'+SUBSTRING(code,2,1000)
/*
111110
112110
113110
114110
115110
*/
单表的 创建新表 存 表中有code字段的表名 用动态循环执行更新