華閱文章網求批量修改數據庫信息的SQL語句
declare @Name2 varchar(8000)--存儲字段name1
declare @Name1 varchar(8000)--存儲字段name2
declare @id varchar(800)--存儲id
declare @result int --存儲數字之間的差
declare change_col cursor for select id,name1,name2 from table
open change_col
fecth next from change_col into @id,@Name1,@Name2
while (@@fetch_status = 0)
begin
set @result = (substring(name1,charindex(name1,'/')+1,5))
if (ABS(@result) >5)
begin
if(right(@name2,2)='\二'）
begin
end
else if (right(@name2,2)='\三'）
begin
update table set name2 = substring(@name2,0,len(@name2)-2）+'/二' where id = @ID
end
else
begin
update table set name2 = @name2 +'/二' where id = @ID
end
end
else
begin
if(right(@name2,2)='\二'）
begin
update table set name2 = substring(@name2,0,len(@name2)-2）+'/三' where id = @id
end
else if (right(@name2,2)='\三'）
begin
end
else
begin
update table set name2 = @name2 +'/三' where id = @id
end
end
fecth next from change_col into @id,@Name1,@Name2
end
close change_col
deallocate change_col
求批量修改數據庫信息的SQL語句
declare @Name2 varchar(8000)--存儲字段name1declare @Name1 varchar(8000)--存儲字段name2declare @id varchar(800)--存儲iddeclare @result int --存儲數字之間的差declare change_col cursor for select id,name1,name2 from table open change_col fecth next from change_col into @id,@Name1,@Name2while (@@fetch_status = 0)begin set @result = (substring(name1,charindex(name1,'/')+1,5)) if (ABS(@result) >5) begin if(right(@name2,2)='\二'） begin end else if (right(@name2,2)='\三'） begin update table set name2 = substring(@name2,0,len(@name2)-2）+'/二' where id = @ID end else begin update table set name2 = @name2 +'/二' where id = @ID end end else begin if(right(@name2,2)='\二'） begin update table set name2 = substring(@name2,0,len(@name2)-2）+'/三' where id = @id end else if (right(@name2,2)='\三'） begin end else begin update table set name2 = @name2 +'/三' where id = @id endend fecth next from change_col into @id,@Name1,@Name2endclose change_coldeallocate change_col。
