sql server 存储过程 声明变量declare @testValue int,默认值是NULL

在sqlServer存储过程中,声明一个变量,但是没有赋值的情况下,其值默认为NULL

测试代码:

create PROCEDURE [dbo].[test]
AS
BEGIN
declare @testValue int
print '声明@testValue 并不赋值'
if(@testValue IS NULL)
	print '@testValue is null'
else
	print '@testValue is not null'
--设置为0
print '赋值@testValue =0'
set @testValue =0
if(@testValue IS NULL)
	print '@testValue is null'
else
	print '@testValue is not null'
END

执行及结果: