declare @a as nvarchar(50)
declare @b as nvarchar(50)
declare @c as nvarchar(50)
set @a=N'aa';
--set @b=N'';
set @c=@a + @b
select @c
declare @b as nvarchar(50)
declare @c as nvarchar(50)
set @a=N'aa';
--set @b=N'';
set @c=@a + @b
select @c
给个初始值,或者isnull
declare @b as nvarchar(50)
declare @c as nvarchar(50)
set @a=N'aa';
--set @b=N'';
set @c=ISNULL(@a,'') + ISNULL(@b,'')
select @c
--aa
declare @b as nvarchar(50)
declare @c as nvarchar(50)
set @a=N'aa';
set @b=null;
set @c=ISNULL(@a,'') + ISNULL(@b,'')
select @c
--aa加isnull处理,判断当@a或@b或NULL(不等于空值)时,赋于空值''
如果不加的话值是无法确定的!