What will be the result? DECLARE @varchar varchar(5) DECLARE @char char DECLARE @int int SELECT @char = 10 SELECT @varchar = (CASE WHEN @char = '*' THEN 1000 * 1000 ELSE '10' + '10' END) SELECT @int = @varchar / 10 SELECT @int

55.

What will be the result?

DECLARE @varchar varchar(5)
DECLARE @char char
DECLARE @int int
SELECT @char = 10
SELECT @varchar = (CASE WHEN @char = '*' THEN 1000 * 1000 ELSE '10' + '10' END)
SELECT @int = @varchar / 10
SELECT @int

ERROR

1000

NONE OF THE ABOVE

View Description

IT WILL GIVE ERROR

Conversion failed when converting the varchar value '*' to data type int