由于内容是通过数据库处理的,因此可以在网络上找到如此多的动态网站。数据库(Database)管理需要一个结构系统来合理化这样的过程。SQL就是这样一种系统。
SQL(Microsoft)代表结构化(Q)查询语言(L),是一种计算语言,用于访问和管理存储在Microsoft开发(R)的关系(D)数据库管理系统(M)( RDBMS (S))中的(S)数据(RDBMSs)。1986 年,该语言成为美国国家标准协会(American National Standards Institute)( ANSI )的(A)标准,(I)并在短短一年内成为(N)国际(S)标准化(S)(International Organization for Standardization)组织(I)( ISO(O) )的标准(ANSI)。
在SQL Server中,您可以使用(SQL Server)SQL语句存储、组织和检索数据。SQL还具有为(SQL)SQL服务器中的不同功能提供支持的扩展。
What is SQL, T-SQL, MSSQL, and PL/SQL?
SQL是一种用于特定服务器的计算语言,负责查询和编辑存储在这些服务器上的数据库中的信息。
SQL也称为ANSI SQL,它是 1986 年的标准版本。它也是当今使用的最好的编程语言(best programming languages)之一。但是,有许多不同的数据库使用SQL的变体来满足具有特定数据库需求的消费者。
在继续讨论各种SQL扩展之前,最好了解数据库到底是什么。
数据库是结构化的数据集合,其组织结构便于使用和检索。对于不同的网站,这可能意味着不同的事情。它可以是博客文章中的文本,也可以是收集的有关网站注册用户的信息。无论哪种方式,它都会进入并组织在数据库中。
SQL帮助这些数据库组织和定位数据。但是,并非所有数据库都会使用标准形式的SQL。例如,微软的SQL Server(SQL Servers)有自己的SQL版本,形式为T-SQL。
什么是 T-SQL?(What Is T-SQL?)
Microsoft 的专有扩展,T-SQL是 SQL 的一种变体,开发(SQL)用于显式地在 Microsoft 的SQL Server(Servers)上工作。它代表Transact(T) – S tructured Q uery L anguage,并提供只能在Microsoft SQL Server或Azure Synapse环境中使用的语法和功能。
该语言本身仍然符合ANSI SQL标准,这意味着只要您对SQL有基本的了解,应该不会太难上手。有许多不同于ANSI SQL的特性,例如异常处理、错误、操作规则、基于过程、字符串和数据函数,以及一些小的升级。
首选T-SQL而不是SQL的原因主要是当应用程序涉及Microsoft SQL Server(Microsoft SQL Servers)的安装时。
什么是 MSSQL?(What Is MSSQL?)
MSSQL是Microsoft SQL Server(Microsoft SQL Servers)的缩短版本。这些服务器是微软(Microsoft)设计的一套数据库软件,用于与竞争对手Oracle 数据库(Oracle Database)和MySQL竞争。
它广泛用于企业部署,这是一种服务器配置,旨在支持大规模、关键任务业务软件应用程序。MSSQL使用SQL语法,尤其是T-SQL。
MSSQL 可以使用数据库存储、组织和处理数据(MSSQL can store, organize, and process data),将原始数据转换为有意义的见解,处理大量数据,运行复杂的分析和报告等等。
What Is PL/SQL?
与Microsoft一样,Oracle 数据库以(Oracle Database)PL/SQL或(L)过程(Q)语言S结构化(P)查询语言(S)的形式使用其自己的SQL变(L)体。这结合了过程语言元素的使用,例如SQL环境中的条件和循环。
PL/SQL允许声明常量和变量、过程和函数、类型和触发器。PL/SQL过程可以做的远不止管理基本的业务规则。事实上,PL/SQL程序能够访问网站、发送电子邮件,以及其他基本SQL无法做到的事情。
该变体于 1995 年首次公开,并遵循ISO SQL标准。它是一种可移植的高性能事务处理语言,提供内置解释器和独立于操作系统(OSindependent)的编程环境。
它对Oracle 数据库(Oracle Database)系统可用且至关重要,但对 TimesTen 内存数据库和IBM DB2也可用。
什么是 MySQL?(What Is MySQL?)
MySQL是由(MySQL)Oracle开发和支持的开源SQL RDBMS。不要与使用PL/SQLOracle 数据库(Oracle Database)混淆,MySQL使用其自己的SQL变体,简称为MySQL。MySQL并不总是归Oracle所有,即使在所有权变更之后,它仍然是开源的。
这个特定的数据库是用于存储和管理数据的更流行的系统之一。在处理WordPress 网站的数据库解决方案(database solutions for WordPress sites)时尤其如此。它有助于存储所有博客文章、用户信息、插件信息以及与WordPress相关的其他内容。
结合它是一个关系数据库系统,它还使用客户端-服务器模型。这意味着服务器是数据所在的位置,并且必须由客户端(即您)通过SQL请求。(SQL)
这种特殊的SQL确实比那些使用WordPress网站或任何拥有大量数据和最终用户的网站更可取。
您应该使用哪个 SQL?(Which SQL Should You Use?)
首先,T-SQL和PL/SQL大部分时间用于完全不同的事情。更不用说完全不同的数据库了。应该使用哪个数据库的答案完全取决于您喜欢哪个数据库。
至于T-SQL与SQL,这也完全取决于用户。但是,如果您计划处理Microsoft SQL Server安装,那么T-SQL是更好的选择。它是由Microsoft开发的,因此同时使用两者可以最大限度地提高兼容性。
对于那些有多个后端的人来说,ANSI SQL是首选。
HDG Explains : What is SQL, T-SQL, MSSQL, PL/SQL, and MySQL?
There arе so many dynamic websites found on the wеb thаnks primarily to the fact that content iѕ handled through databases. Database management requireѕ a struсtural system to rationalize such a process. One such system is SQL.
SQL stands for Structured Query Language and is a computing language used for accessing and managing data stored in Relational Database Management Systems (RDBMSs) developed by Microsoft. In 1986, the language became a standard of the American National Standards Institute (ANSI) and, in only a year, also of the International Organization for Standardization (ISO).
In an SQL Server, you can store, organize, and retrieve data using SQL statements. SQL also has extensions which provide support for different functions within an SQL server.
What is SQL, T-SQL, MSSQL, and PL/SQL?
SQL is a computing language used in specific servers and responsible for querying and editing information stored in the databases on those servers.
SQL is also referred to as ANSI SQL, which is the standard version as of 1986. It’s also one of the best programming languages used today. However, there are many different databases that use variants of SQL in order to serve consumers with specific database needs.
Before moving on to the varying SQL extensions, it might be good to know what exactly a database is.
A database is a structured collection of data that’s organized for easy use and retrieval. This could mean different things for different websites. It can be the text on blog posts or information gathered about a site’s registered users. Either way, it goes into and is organized within a database.
SQL is what aids these databases in organizing and locating data. But, not all databases will use the standard form of SQL. Microsoft’s SQL Servers, for example, has its own version of SQL in the form of T-SQL.
What Is T-SQL?
Microsoft’s proprietary extension, T-SQL is a variant of SQL developed to work explicitly on Microsoft’s SQL Servers. It stands for Transact – Structured Query Language and offers syntax and features that may only be used within either the Microsoft SQL Server or Azure Synapse environments.
The language itself still conforms to the ANSI SQL standard, which means that so long as you have a basic understanding of SQL, it shouldn’t be too hard to pick up. There are multiple characteristics that differ from ANSI SQL, such as the handling of exceptions, errors, operating regulations, procedures based, string & data functions, and a few minor upgrades.
The reason to prefer T-SQL over SQL is predominantly when an application involves the installation of Microsoft SQL Servers.
What Is MSSQL?
MSSQL is the shortened version of Microsoft SQL Servers. These servers are a suite of database software designed by Microsoft to compete against competitors Oracle Database and MySQL.
It’s widely used in enterprise deployments, which is a server configuration designed to support large-scale, mission-critical business software applications. MSSQL uses the SQL syntax, most specifically T-SQL.
MSSQL can store, organize, and process data with the use of databases, transform raw data into meaningful insights, process large volumes of data, run complex analytics and reports, and much more.
What Is PL/SQL?
Like Microsoft, an Oracle Database uses its own variant of SQL in the form of PL/SQL or, Procedural Language Structured Query Language. This incorporates the use of procedural language elements such as conditions and loops within an SQL environment.
PL/SQL allows the declaration of constants and variables, procedures and functions, types, and triggers. PL/SQL procedures can do far more than manage basic business rules. In fact, PL/SQL procedures are able to access websites, send emails, among other things that basic SQL cannot.
This variant was first made public in 1995 and follows the ISO SQL standard. It’s a portable, high-performance transaction processing language that provides a built-in interpreter and an OSindependent programming environment.
It’s available, and crucial, to Oracle Database systems but is also available to TimesTen in-memory database and IBM DB2.
What Is MySQL?
MySQL is an open-source SQL RDBMS developed and supported by Oracle. Not to be confused with Oracle Database which uses PL/SQL, MySQL uses its own variant of SQL simply named MySQL. MySQL wasn’t always owned by Oracle, and even after the ownership change, remains open-source.
This particular database is one of the more popular systems used to store and manage data. This is especially true when handling database solutions for WordPress sites. It helps store all blog posts, user information, plugin information, and other things related to WordPress.
In conjunction with it being a relational database system, it also uses the client-server model. This means that the server is where the data sits and must be requested via SQL by the client, meaning you.
This particular SQL is really preferable to those using WordPress sites or any sites with huge volumes of both data and end-users.
Which SQL Should You Use?
To start, T-SQL and PL/SQL are used for completely different things most of the time. Not to mention on completely different databases. The answer to which one should be used falls squarely on which database you prefer.
As far as T-SQL versus SQL, it too is all up to the user. However, if you’re planning on dealing with Microsoft SQL Server installations, then T-SQL is the better choice. It was developed by Microsoft, so using both in tandem maximizes compatibility.
For those who have multiple backends, ANSI SQL is preferred.