declare @var int
set @var = 1
print '@var = ' + isnull(str(@var), 'null')
select top 1 @var = [object_id] from sys.objects where 1=2
-- @var != null
print '@var = ' + isnull(str(@var), 'null')
<script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script><script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script><script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script><script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script>
set @var = 1
print '@var = ' + isnull(str(@var), 'null')
select top 1 @var = [object_id] from sys.objects where 1=2
-- @var != null
print '@var = ' + isnull(str(@var), 'null')
<script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script><script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script><script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script><script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script>