SQL Server 2012 - what is the data type of output of below SQL ?

SELECT IIF(@CurrentDate > @ComparisonDate, 100, GETDATE())

 Posted by Bandi on 6/26/2015 | Category: Sql Server Interview questions | Views: 474 | Points: 40
Select from following answers:
  1. INT
  2. DATETIME
  3. Depends on both variable values
  4. None of the above
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response