SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)

gvarol@corelogic.com

SQL Prompt formats
SELECT IS_ROLEMEMBER('db_owner') ;

to

SELECT [IS_ROLEMEMBER]('db_owner') ;
Which becomes invalid.


Some other functions from site
https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-2017

@CONNECTIONS

@CPU_BUSY

@CURSOR_ROWS

@DATEFIRST

@DBTS

@FETCH_STATUS

@IDLE

@IO_BUSY

@LANGID

@LANGUAGE

@LOCK_TIMEOUT

@MAX_CONNECTIONS

@MAX_PRECISION

@NESTLEVEL

@OPTIONS

@PACK_RECEIVED

@PACK_SENT

@PACKET_ERRORS

@PROCID

@REMSERVER

@SERVERNAME

@SERVICENAME

@SPID

@TEXTSIZE

@TIMETICKS

@TOTAL_ERRORS

@TOTAL_READ

@TOTAL_WRITE

@VERSION

ABS

ACOS

APP_NAME

APPLOCK_MODE

APPLOCK_TEST

ASCII

ASIN

ASSEMBLYPROPERTY

ATAN

ATN2

CEILING

CERTENCODED

CERTPRIVATEKEY

CHAR

CHARINDEX

COL_LENGTH

COL_NAME

COLUMNPROPERTY

CONCAT

CONCAT_WS

COS

COT

CURRENT_USER

CURSOR_STATUS

DATABASE_PRINCIPAL_ID

DATABASE_PRINCIPAL_ID

DATABASEPROPERTYEX

DB_ID

DB_NAME

DEGREES

DIFFERENCE

EXP

Extracts a scalar value from a JSON string.

Extracts an object or an array from a JSON string.

FILE_ID

FILE_IDEX

FILE_NAME

FILEGROUP_ID

FILEGROUP_NAME

FILEGROUPPROPERTY

FILEPROPERTY

FLOOR

fn_virtualfilestats

FORMAT

FULLTEXTCATALOGPROPERTY

FULLTEXTSERVICEPROPERTY

HAS_PERMS_BY_NAME

INDEX_COL

INDEXKEY_PROPERTY

INDEXPROPERTY

IS_MEMBER

IS_ROLEMEMBER

IS_SRVROLEMEMBER

ISJSON

JSON_MODIFY

JSON_QUERY

JSON_VALUE

LEFT

LEN

LOG

LOG10

LOWER

LTRIM

NCHAR

NEXT VALUE FOR

OBJECT_DEFINITION

OBJECT_ID

OBJECT_NAME

OBJECT_SCHEMA_NAME

OBJECTPROPERTY

OBJECTPROPERTYEX

ORIGINAL_DB_NAME

ORIGINAL_LOGIN

PARSENAME

PATINDEX

PERMISSIONS

PI

POWER

PWDCOMPARE

PWDENCRYPT

QUOTENAME

RADIANS

RAND

REPLACE

REPLICATE

REVERSE

RIGHT

ROUND

RTRIM

SCHEMA_ID

SCHEMA_ID

SCHEMA_NAME

SCHEMA_NAME

SCOPE_IDENTITY

SERVERPROPERTY

SESSION_USER

SIGN

SIN

SOUNDEX

SPACE

SQRT

SQUARE

STATS_DATE

STR

STRING_AGG

STRING_ESCAPE

STRING_SPLIT

STUFF

SUBSTRING

SUSER_ID

SUSER_NAME

SUSER_SID

SUSER_SNAME

sys.fn_builtin_permissions

sys.fn_get_audit_file

sys.fn_my_permissions

SYSTEM_USER

TAN

Tests whether a string contains valid JSON.

TEXTPTR

TRANSLATE

TRIM

TYPE_ID

TYPE_NAME

TYPEPROPERTY

UNICODE

Updates the value of a property in a JSON string and returns the updated JSON string.

UPPER

USER_ID

USER_NAME

VERSION

Tianjiao_Li

Thanks for reporting this issue!

Can you share your format style file with me as I wasn't able to reproduce it with the default one.

Thanks.

gvarol@corelogic.com

https://forum.red-gate.com/discussion/85869/sqlprompt-9-5-18-11513-still-misformats-is-rolemember-and-makes-the-sql-statement-invalid#latest

Tianjiao_Li

It's odd that it still works fine with your style file for me. I'll reach out by email for more information.

Thanks.