SQL: select @var = xxx from table1 problem

来源:互联网 发布:arm-linux-gcc官网 编辑:程序博客网 时间:2024/06/05 04:16
 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')


原创粉丝点击