What are the challenges you face when working across database platforms? Take the survey
Options

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

Answers

Sign In or Register to comment.