none
SQL46010: Incorrect syntax near ) RRS feed

  • General discussion

  • Hello.

    I have strange behavior in our project with last SSDT for VS2017.

    This code is valide sql code, but SSDT gives me the next error:

    create procedure test as if (iif(1 = 1, 1, 0) ) < 2 select 'ok'

    Severity	Code	Description	Project	File	Line	Suppression State
    Error		SQL46010: Incorrect syntax near ).	Stored Procedures\Procs2\test.sql	4	
    
    Is it an error in SSDT?

    • Changed type aleksandrus Friday, March 16, 2018 12:52 PM
    Friday, March 16, 2018 12:50 PM

All replies