34,593
社区成员
发帖
与我相关
我的任务
分享
declare @a varchar(4000),@b varchar(4000)
select @a='aaaaaaa',@b='bbbbbbb'
select @a=b,@b=a FROM (select @a AS a,@b AS b) as ab
select @a as a ,@b as b
/**
a b
bbbbbbb aaaaaaa
**/
DECLARE @a varchar(50),@b varchar(50)
SELECT @a='AA',@b='BBB'
SET @a=@a+@b
SET @b=LEFT(@a,LEN(@a)-LEN(@b))
SET @a=RIGHT(@a,LEN(@a)-LEN(@b))
SELECT @a AS a,@b AS b
/**
a b
BBB AA
**/
declare @a int,@b int
select @a=2,@b=5
set @a=@a+@b
set @b=@a-@b
set @a=@a-@b
select @a as 'a',@b as 'b'
/*
a b
5 2
*/
这个题目人家经常用来面试