Backstory: For a little over a month now, I’ve been darting between online forums for help on this. I’m new to .net and couldn’t get ssdt or ssms to work on my visual studio in spite of every effort on my part (a story for another day), so I resorted to SQL operations studio, which requires running the queries manually but I discovered the three sql tables created and exported from phpmyadmin, were non-compliant in mssql environment, even though they’re both supposedly children of the same sql standard. There are error markings wherever I have backticks and even when I omit them, the complaint still stands. On further investigation, I now observed it could be because my tables (or the table I’m trying to create) is not “fully qualified” i.e. has no schema. I don’t know how to create a schema or where to find one. In node.js, a schema corresponds to the table structure (which is what I’m trying to create now) so why complain about it before the table is created to begin with?
I’ve tried wrapping the conditions like if and exists in brackets but the script still throws errors on almost every single line. I’ve also looked up differences between mysql and mssql syntax but that hasn’t done me any good either.
Since I cannot find any GUI alternative to sql operations studio i.e. a phpmyadmin variant for mssql, I now want to learn mssql but much to my amazement, I can’t seem to find any books for mssql command reference or study. Google searches keep bringing up results for sql books while I clearly do not want since the language apparently adheres to no standards. I’d really appreciate if anyone can recommend a book that teaches basic things like getting up and running, creating a table via command line or programs like sql operations studio, what a schema means in this context and how to access it, WITHOUT THE OBJECT/SERVER EXPLORER IN VISUAL STUDIO (which as previously mentioned, has defied all my attempts to utilize. See). The three-table queries can be found on this bin. Thank you.