SQL Graph Support
Dave Pendleton
Posts: 104 Bronze 3
in SQL Prompt
It appears that SQL Prompt still does not completely support SQL Graph databases in SQL Server 2022 or Azure SQL Database:
Format SQL does not work correctly, or at all.
Add Square Brackets brackets Graph keywords when they shouldn't be.
Qualify object names does not work.
Suggestions do not work much of the time.
Currently, I'm testing with the Microsoft GraphDemo objects and code from Books Online.
Is this still a work in progress, or is something else required? I am using:
Azure SQL Database
SQL Server 16.0.4085.2
SQL Server Management Studio 19.2
SQL Prompt 10.14.1.4347
Format SQL does not work correctly, or at all.
Add Square Brackets brackets Graph keywords when they shouldn't be.
Qualify object names does not work.
Suggestions do not work much of the time.
Currently, I'm testing with the Microsoft GraphDemo objects and code from Books Online.
Is this still a work in progress, or is something else required? I am using:
Azure SQL Database
SQL Server 16.0.4085.2
SQL Server Management Studio 19.2
SQL Prompt 10.14.1.4347
Tagged:
Answers
Thank you for your forum post.
Using the GraphDemo database from this Microsoft Learn document
I am unable to replicate the reported fault symptoms in your forum post.
I am able to format the T-SQL code selecting the various Redgate default style options (from SQL Prompt menu ->Active Style ->Either selecting a previous customer style or selecting a Redgate Default Style. ->Fomat SQL / Ctrl+K, Ctrl+y).
Square brackets are not added (from SQL Prompt menu ->Options ->Format ->Styles ->Actions ->the Add/remove square brackets check box is checked with the Remove unnecessary brackets option).
Suggestions operate as expected. However, I may have difference in the SQL Prompt options to yourself.
Qualify Object names worked as expected in my reproduction attempt:
Before:
After Qualify Object Names:
I believe the version of SQL Prompt and SSMS are identical to you:
SQL Prompt V10.14.1.4347
SSMS 19.2 / 19.2.56.2
I do have a difference in SQL Server Version, in that I am using an On-premise SQL Instance of SQL 2022 / 16.0.1105.1.
What options do you have configured in your SQL Prompt Menu ->Options ->Format ->Styles ->Actions?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
I have all the Microsoft Learn example code in one script, when I format using my options, the following error(s) are introduced into a previously error-free script:
My options are: