How can we help you today? How can we help you today?

SQL Prompt is bracketing the TRIM function in Visual Studio 2019

Prompt version 10.13.7.360
Visual Studio 18.12.1

This does not happen in SQL Server Management Studio.
Dave Pendleton
0

Comments

4 comments

Sort by
  • dkim1999
    Hi Dave,

    Thank you for reaching out about SQL Prompt.

    I am unable to recreate the issue you are seeing. What version of Visual Studio are you running?]

    Kind Regards,
    David K.
    Product Support Engineer
    dkim1999
    0
  • Dave Pendleton
    ^ 18.12.1

    TRIM(someColumn)

    becomes

    [TRIM](someColumn)

    which is invalid. This happens in the code for a VIEW. It doesn't happen when the same code is formatted in SQL Server Management Studio.
    Dave Pendleton
    0
  • ATurner
    Hi Dave Pendleton

    I require a bit of further information on this issue so I am going to raise a ticket.
    ATurner
    0
  • Dave Pendleton
    This is also occurring with other built-in Transact functions, most recently STRING_AGG.
    Dave Pendleton
    0

Add comment

Please sign in to leave a comment.