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

SQLPrompt 9.5.18.11513 still misformats IS_ROLEMEMBER and makes the sql statement invalid

SQLPrompt 9.5.18.11513 formats
SELECT IS_ROLEMEMBER('db_owner')
to
SELECT [IS_ROLEMEMBER]('db_owner') 
and the sql becomes invalid

The list of sql server functions can be found at
https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-2017

gvarol
0

Comments

6 comments

Sort by
  • squigley
    Good Morning!
    Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.
    Can you go into more detail on how you get this incorrect format?
    I tried replicating this on my end by typing out the same SQL line, but SQL Prompt never formats it to have [] even when I try to force it manually.
    squigley
    0
  • gvarol

    gvarol
    0
  • gvarol
    Also I noticed if there is something wrong in the sql and it fails to format it stull puts square brackets ([]) around ISNULL, QUOTENAME, SCHEMA_NAME etc function, check that out too.
    gvarol
    0
  • squigley
    Thanks for those screenshots and details.
    Can you confirm what version you're seeing this under? The developers have informed me that the current latest version 9.5.18 should be able to handle this better.
    squigley
    0
  • gvarol
    it's in the subject of the ticket.
    gvarol
    0
  • Tianjiao_Li
    Thanks @gvarol@corelogic.com

    As I said on https://forum.red-gate.com/discussion/85883/sql-prompt-misformats-is-rolemember-function-version-9-5-16-11294 I'll reach out by email for more information.

    Thanks.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.