Question

SQL SERVER同一表中的A字段的值更新成B字段的值（急！！！）

表里面的每条记录都是把A字段的值更新为B字段的值
我已经解决了，拿来跟大家分享，谢谢大家了 DECLARE @ID INT
DECLARE @T VARCHAR(50)
DECLARE aa CURSOR FOR
SELECT photoid,url FROM tnet_photo
OPEN aa
FETCH NEXT FROM aa INTO @ID,@T
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE tnet_photo SET surl=@t WHERE photoid=@ID
FETCH NEXT FROM aa INTO @ID,@T
END
CLOSE aa
DEALLOCATE aa

Answer 1

用触发器，

B的值改变A的值随即改变，

或者先取出B的值再SQL语句修改A的值

Answer 2

create view v
as
select a1.A,a2.A,a1.B,a2.B from a a1 inner join a a2 on a1.A=a2.A;
go
update v set a1.A = a2.B where a1.A=a2.A
go

Answer 3

update tableName set a=b
我测试了 完全可以的

Answer 4

update table set a=b where 条件

记得是可以这样的...

ab是字段名称