Which version of SQL should I use?

Question

Post reply

Which version of SQL should I use?

curtisharrington

SSC Enthusiast

Points: 172
More actions
November 27, 2021 at 4:57 am

#3957377

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.
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
May 3, 2023 at 6:54 am

This was removed by the editor as SPAM
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

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004052 More actions · Answer 2

curtisharrington wrote:

Now I am using SQL to manage school data.

What are you currently using?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Michael L John One Orange Chip Points: 27048 More actions · Answer 3

curtisharrington wrote:

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/

ganatbasa Newbie Points: 1 More actions · Answer 4

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.

Jeff Moden SSC Guru Points: 1004052 More actions · Answer 5

ganatbasa wrote:

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

helenmcneil20 Grasshopper Points: 12 More actions · Answer 6

curtisharrington wrote:

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!

gulshan212 SSC Enthusiast Points: 194 More actions · Answer 7

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