User Profile
Arulmouzhi
MCT
Joined 6 years ago
User Widgets
Recent Discussions
Azure Synapse Analytics Dedicated SQL pool - IIF statement Support required
Trying to use IIF() in SELECT statement and getting the error "Incorrect syntax near '>'." in Azure Synapse Analytics-Dedicated SQL pool Tried like below: SELECT IIF(1>2, 'YES', 'NO'); This(attached pic as ref) error makes me to believe that IIF statement is not working at all in Azure Synapse Analytics Dedicated SQL Pool. Also this document link confirms that as well - IIF (Transact-SQL) - SQL Server | Microsoft Docs Knew that, CASE is alternative, but want to know Is there any specific reason behind this non-working of IIF (or) not implementing in Synapse Dedicated SQL pool? Any know-how regarding this is much appreciated!8.4KViews1like3Comments
Recent Blog Articles
No content to show