sql 中计算字符串中的算术

DECLARE @NUM VARCHAR(20)
SET @NUM = '1+1'
DECLARE @STR VARCHAR(50)
SET @STR = 'select ' + @NUM
EXEC (@STR)