Understanding conversion issue nvarchar to tinyint
I try this query on SQL Server but I got an error
Understandinf conversion issue nvarchar to tinyint
I try this query on SQL Server but I got an error
I can not understand how activity of this query in SQL SERVER
I try this query on sqlserver but I got an error “Conversion failed when converting the nvarchar value ‘Trên bàn ‘ to data type smallint.”, I knew that because the subquery could not return a value, but when I run the subquery independently, I will got the right value. I don’t know why, explain for me please, thank you so much.
enter image description here
this is the result when I query subquery indepently
enter image description here