(There are a lot of other strange things about this database and application which I could author an article on, so I won't go into it further here.) Perhaps, not having any primary or foreign keys is making it difficult for ADS to produce any results or messages from the SQL Script when I run it. I don't know why whoever designed this database, didn't bother putting in any keys or relating any table with any other table.
For all intents and purposes, whoever designed this database could have used flat files or Excel spreadsheets, because all the database logic is performed by the app.
SQL Server Management Studio (SSMS) is for many people still the default choice it used to be included with a SQL Server installation, it is the most familiar tool for most SQL Server professionals, it gives easy. The results of this query are not cached, since the cache applies to charts. Microsoft has two main tools for querying and managing SQL Server databases in a graphical UI. When you run DMV queries to look at query plans, they show up as XML, which isn’t very friendly. It’s still relatively young, so it has some missing areas of functionality. And none of the tables have foreign keys to any other table. Lets say your data source connects to a custom SQL query: SELECT FROM tableName. Azure Data Studio is Microsoft’s cross-platform tool for T-SQL developers. None of the tables in this database have any primary key. It would be kind of a special case, dependent upon my writing a SQL script instead of an ad hoc query, but here goes. (I left out some things from the script I felt shouldn't be put in a GitHub issue.) Doing so I realized there might be a cause about this, related to the database. There I decided to enter the complete SQL Script I've been working on in an issue on ADS, in GitHub. Yesterday I entered feedback in ADS on this issue.
And normally, if I'm not connected to a database in ADS, hitting the Play button brings up a popup complaining about not being connected. I often have another query window open in ADS, so I can do a quick SELECT to check something, while working on the SQL script in the other query window.
0 kommentar(er)
