Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
SQL Server 2012 - what is the data type of output of below SQL ?
SELECT IIF(@CurrentDate > @ComparisonDate, 100, GETDATE())
on 6/26/2015 | Category:
Sql Server Interview questions
| Views: 522 |
Select from following answers:
Depends on both variable values
None of the above
IIF() function introduced in SQL server 2012. this function returns the data type with the highest precedence between the 2nd parameter (true value) and the 3rd parameter (false value). From the given query, DATETIME has a higher precedence than INT.
Show Correct Answer
Many Interviews |
< Previous :
SQL Server 2012 - Which of the following statement ...
Next > :
SQL Server 2012 - what is the output of below quer ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
SQL Server 2012 - what is the output of below query ? SELECT CONCAT ...
Which of the following creates index automatically in database?
Which type of recovery model doesn't log any type of changes?
In which type od index, the bottom level of an index doesn’t contain d ...
Which type of cursor doesn't locks the records/rows that are read ...
With which type of SQL server recovery model are all db changes logged ...
Which of the following refers to the SQL Server transaction isolation ...
In SQL server, which of the following makes a copy of the changes that ...
Latest Interview Questions
What are HttpHandlers and HttpModules in ASP.NET?
Which one of the following is used to obtain performance information a ...
Which of the following is the fastest way to concat strings in ASP.NET ...
____________ is the Microsoft IIS server running , handling ASP.NET re ...
Which of the following object encapsulates the state of client and the ...
Which one of the following is the type of assembly that contains local ...
When does garbage collector runs ?
__________ is the first method that is fired during the page load ?