这是你期望的吗?
SELECT TOP(1)
content.content_id AS content_id ,
content.content_type AS content_type ,
content.content_name AS content_name ,
content.content_version AS content_version ,
content.effective_date AS effective_date
FROM test_content content
WHERE content.vendor_id = :vendor_id
AND content.content_type = :content_type
AND content.content_name =
CASE
WHEN :content_type2 <> 'T'
THEN :content_name
ELSE content.content_name
END
ORDER BY content_version DESC