1.SQL-SERVER 2005 在编写T-sql 时,如果是字符串变量拼接,要判断字符串是否为空,否则拼接后为NULL:
如:
declare @code nvarchar(10),
@name nvarchar(20),
@test nvarchar(30);
set @code = 'ABC1001';
print '@code:' + @code;
set @name = null;
/*注意这里,拼接之后的字符串就为null了*/
set @test = @code+@name;
print '@test :' + @test;
应改为:
declare @code nvarchar(10),
@name nvarchar(20),
@test nvarchar(30);
set @code = 'ABC1001';
print '@code:' + @code;
set @name = null;
/*注意这里,拼接之后的字符串就为null了*/
set @test = isnull(@code,'')+isnull(@name,' is null');
print '@test :' + @test;
其他注意事项待更新…………