I think thats because of else condition having 1 which forces it to convert implicitly to int type
try like this and then you will get varbinary result
--THis Case Statement Not returning Result set in Varbinary .
select case @check when 1 then @val else cast(1 as varbinary) end as value
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c
No comments:
Post a Comment