SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)
gvarol@corelogic.com
Posts: 90 Bronze 3
in SQL Prompt
SQL Prompt formats
SELECT IS_ROLEMEMBER('db_owner') ;
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
Which becomes invalid.
Some other functions from site
https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-2017
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
