[font="Verdana"]

Create Table #Table

(

valint

)

Go

Select val From #Table

Go

Declare @valint

Select @val

Go

Declare @valint

Set @val = Null

Select @val

Go

Declare @valint

Select@val = Null From #Table

Select@val

Go

Declare @valint

Select@val = val From #Table

Select@val

Go

Declare @valint

Select@val = (Select val From #Table)

Select@val

Go

Drop Table #Table

Go

All the options mentioned in QoD returns NULL. So ideally speaking answer should contain all the options.

Mahesh[/font]