November 27, 2021 at 4:57 am
I see SQL as a query language, used to store and retrieve data. However, there are now many versions of new words with different features. Now I am using SQL to manage school data. So now which version should I use? Please give me some advice.
November 28, 2021 at 5:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 28, 2021 at 11:29 pm
Now I am using SQL to manage school data.
What are you currently using?
--Jeff Moden
Change is inevitable... Change for the better is not.
November 29, 2021 at 3:37 pm
I see SQL as a query language, used to store and retrieve data. However, there are now many versions of new words with different features. Now I am using SQL to manage school data. So now which version should I use? Please give me some advice.
ANSI-SQL is the international standard.
Microsoft has implemented that, and extended the language as T-SQL. Oracle has done the same thing as PL-SQL. Each RDMS has implemented various extensions to the original language.
The RDMS you choose determines what dialect of SQL is available to you.
Choosing an RDMS is probably more dependent upon costs, time to learn the RDMS, and your infrastructure.
When you say "there are now many versions of new words with different features", what specifically are you referring to?
The word SELECT is universal to all dialects. However, TRY_CONVERT is specific to T-SQL (Microsoft)
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 4, 2022 at 7:39 am
This was removed by the editor as SPAM
March 7, 2022 at 4:31 am
This was removed by the editor as SPAM
April 15, 2023 at 7:03 am
While a lot of us I doubt have much choice in what version we use for those that have used multiple version of SQL what version do you prefer to use?
I'm in the process of migrating scripts from MySQL to SQL server and I'm really missing a lot of MySQL's quality of life features.
April 16, 2023 at 4:52 am
While a lot of us I doubt have much choice in what version we use for those that have used multiple version of SQL what version do you prefer to use?
I'm in the process of migrating scripts from MySQL to SQL server and I'm really missing a lot of MySQL's quality of life features.
(PPTS)
Personally, I have little knowledge of MySQL's "quality of life" features. Can you outline a couple of such features so that we might be able to help you with comparable features in SQL Server.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2023 at 6:54 am
This was removed by the editor as SPAM
July 20, 2023 at 9:26 am
I see SQL as a query language, used to store and retrieve data. However, there are now many versions of new words with different features. Now I am using SQL to manage school data. So now which version should I use? Please give me some advice.
Hey Curtis! Considering you're managing school data, I'd recommend using PostgreSQL. It offers advanced features and support for complex data types, making it a great choice for handling diverse school-related information effectively. Best of luck with your SQL journey!
September 18, 2023 at 5:35 pm
Well, the choice of choosing SQL version depends on several factors such as which version of DBMS you are using, other special requirement. Some of SQL versions are listed below:
1. SQL-92 (ANSI SQL)
2. SQL:1999 (SQL3)
3. SQL:2003
4. SQL:2008
5. SQL:2011
6. SQL:2016
7. SQL:2019
8. Database-Specific SQL Variants
9. Legacy SQL Versions
Thanks
March 27, 2024 at 2:55 pm
This was removed by the editor as SPAM
March 27, 2024 at 2:56 pm
This was removed by the editor as SPAM
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply