About SQL, MySQL and TSQL

Asked By Mickhel 70 points N/A Posted on - 10/07/2011

Internet users and web builders and any other person some times see that type of SQL, MySQL, TSQL. Actually I do not know what is it but I think that it is some kind of a server after all I have needed to know about it. Can anybody explain what is SQL, MySQL , and TSQL ? and its uses.

Puja

• Status: Open
• Question Views: 1006
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by jamespop

Go To Solution

Best Answer

Best Answer

Answered By jamespop 0 points N/A #87388

About SQL, MySQL and TSQL

SQL: SQL stands for 'Structured Query Language'. It is a standard language designed to manage data in relational database management system on the web. SQL is an ANSI (American National Standards Institute) standard that lets you access and manipulate databases. Also it can delete records from a database and create new databases.

MySQL: It is the most popular open source relational database management system (RDBMS). MySQL is very fast, more reliable and flexible in relational database management system on the web.

T-SQL: T-SQL means 'Transaction-SQL' and it is a Microsoft's and Sybase's proprietary extension to SQL.

Hope this helps you.

Thanks.

About jamespop

Questions
0

Answers
3

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/14/2011
• Question Category: MS SQL Server

Answered By Sharath Reddy 590495 points N/A #87389

About SQL, MySQL and TSQL

SQL stands for Structured Query Language. It is a standardized programming language intended for managing relational databases and doing different operations on the data. It was originally created back in the 70s and is regularly used by database administrators including developers writing data integration scripts as well as data analysts searching to set up and run analytical queries.

When SQL emerged in the late 70s and early 80s, it became the de facto standard programming language for relational databases. MySQL, on the other hand, is an open source relational database management system or RDBMS that is based on SQL and runs virtually on all platforms such as Microsoft Windows, UNIX, and Linux.

Though MySQL can be used in a wide range of applications, it is frequently used on web-based applications and online publishing. It is also a vital component of LAMP, an open source enterprise stack. LAMP is a web development platform that uses Linux as the operating system, MySQL as the relational database management system, Apache as the web server, and PHP as the scripting language.

TSQL or T-SQL stands for Transact-SQL. It is a set of programming extensions from Microsoft and Sybase that add several features to SQL like transaction control, row processing, declared variables, and exception and error handling. T-SQL statements are supported by Microsoft SQL Server and Sybase SQL server.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 10/12/2016
• Question Category: MS SQL Server