I have the below two expressiong in SQL Server. I wanted to understand which one is more efficient. ANy test I can run to understand which one would be more efficient.
Option A :
SET @StartingPoint = CONVERT(VARCHAR(30),CONVERT(VARCHAR,@QuestionID) + '#' + CONVERT(VARCHAR,@CurrentAnswerOption))
SET @StartingPoint = CONCAT(@QuestionID, '#', @CurrentAnswerOption)