34,576
社区成员
发帖
与我相关
我的任务
分享
----------------------------------------------------------------
-- Author :DBA_HuangZJ(發糞塗牆)
-- Date :2014-07-16 10:56:33
-- Version:
-- Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
-- May 14 2014 18:34:29
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
--
----------------------------------------------------------------
--> 测试数据:[huang]
if object_id('[huang]') is not null drop table [huang]
go
create table [huang]([id] int,[va] varchar(1),[vb] varchar(1),[vc] varchar(1))
insert [huang]
select 1,'a','b','c' union all
select 2,'c','d','e' union all
select 3,'e','f','g'
--------------开始查询--------------------------
SELECT * FROM huang WHERE id=1
UPDATE huang SET VA=4,VC=VB,VB=VA WHERE ID=1
SELECT * FROM huang WHERE id=1
----------------结果----------------------------
/*
id va vb vc
----------- ---- ---- ----
1 a b c
(1 行受影响)
(1 行受影响)
id va vb vc
----------- ---- ---- ----
1 4 a b
*/