求助~~关于sql 语句... 更正一下:然后更新这张表,第一行第一列a为10 ,第一行第二列b=30;第二行第一列a=11,第二行第二列b=31; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://hiphotos.baidu.com/xuetaobd/mpic/item/e7d3a5188e55012434fa41fd.jpg DECLARE @T TABLE(ID INT,A INT ,B INT )INSERT @T SELECT 1,1,2INSERT @T SELECT 2,1,2INSERT @T SELECT 3,1,2INSERT @T SELECT 4,1,2INSERT @T SELECT 5,1,2INSERT @T SELECT 6,1,2INSERT @T SELECT 7,1,2INSERT @T SELECT 8,1,2INSERT @T SELECT 9,1,2INSERT @T SELECT 10,1,2DECLARE @A INT DECLARE @B INT SET @A=9SET @B=29UPDATE @T SET A=@A,@A=@A+1,B=@B,@B=@B+1SELECT * FROM @T/*ID A B ----------- ----------- ----------- 1 10 302 11 313 12 324 13 335 14 346 15 357 16 368 17 379 18 3810 19 39*/ declare @i int,@j int,set @I = 9set @j = 29update ta set a = @i,b = @J,@i = @i +1,@J =@j +1 declare @a int ,@b intupdate tb set @a=case when @a=0 then 10 else @a+1 end,@b=case when @b=0 then 30 else @a+1 end,a=@a,b=@b DECLARE @T TABLE(ID INT,A INT ,B INT )INSERT @T SELECT 1,1,2INSERT @T SELECT 2,1,2INSERT @T SELECT 3,1,2INSERT @T SELECT 4,1,2INSERT @T SELECT 5,1,2INSERT @T SELECT 6,1,2INSERT @T SELECT 7,1,2INSERT @T SELECT 8,1,2INSERT @T SELECT 9,1,2INSERT @T SELECT 10,1,2declare @a int ,@b intselect @a=0,@b=0update @T set @a=case when @a=0 then 10 else @a+1 end,@b=case when @b=0 then 30 else @b+1 end,a=@a,b=@bselect * from @T/*ID A B ----------- ----------- ----------- 1 10 302 11 313 12 324 13 335 14 346 15 357 16 368 17 379 18 3810 19 39(所影响的行数为 10 行)*/ ok le , thank you very much ~~ 无限级分类问题,在线等待!!! sqlserver自定义函数调用报错 SQL语句转换请教 视图主键? 按日期Select,Group by出现问题,请教!!! sql2000 安装问提??(不是挂起的问题)急~~~ SQL中能计算字符创公式 又是关于触发器的,很菜的问题。 急求教 注册 sql sever 服务器的问题? 专家!请问互相包含的SQL问题! 急!!!高手进来 两表关联问题
INSERT @T SELECT 1,1,2
INSERT @T SELECT 2,1,2
INSERT @T SELECT 3,1,2
INSERT @T SELECT 4,1,2
INSERT @T SELECT 5,1,2
INSERT @T SELECT 6,1,2
INSERT @T SELECT 7,1,2
INSERT @T SELECT 8,1,2
INSERT @T SELECT 9,1,2
INSERT @T SELECT 10,1,2
DECLARE @A INT
DECLARE @B INT
SET @A=9
SET @B=29
UPDATE @T SET A=@A,@A=@A+1,B=@B,@B=@B+1
SELECT * FROM @T
/*ID A B
----------- ----------- -----------
1 10 30
2 11 31
3 12 32
4 13 33
5 14 34
6 15 35
7 16 36
8 17 37
9 18 38
10 19 39*/
set @I = 9
set @j = 29
update ta
set a = @i,b = @J,@i = @i +1,@J =@j +1
update tb set @a=case when @a=0 then 10 else @a+1 end,@b=case when @b=0 then 30 else @a+1 end,a=@a,b=@b
INSERT @T SELECT 1,1,2
INSERT @T SELECT 2,1,2
INSERT @T SELECT 3,1,2
INSERT @T SELECT 4,1,2
INSERT @T SELECT 5,1,2
INSERT @T SELECT 6,1,2
INSERT @T SELECT 7,1,2
INSERT @T SELECT 8,1,2
INSERT @T SELECT 9,1,2
INSERT @T SELECT 10,1,2declare @a int ,@b int
select @a=0,@b=0
update @T set @a=case when @a=0 then 10 else @a+1 end,@b=case when @b=0 then 30 else @b+1 end,a=@a,b=@bselect * from @T
/*ID A B
----------- ----------- -----------
1 10 30
2 11 31
3 12 32
4 13 33
5 14 34
6 15 35
7 16 36
8 17 37
9 18 38
10 19 39(所影响的行数为 10 行)
*/