Overview of T-SQL

Overview of T-SQL
Techiio-author
Written by Shuvhojit DebDecember 22, 2021
7 min read
T-SQL
0 VIEWS 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWS SHARE
Techiio-author
Shuvhojit Deb

Full Stack Developer

In this blog, we'll know everything about T-SQL.

What is T-SQL

TSQL stands for Transact structured Query language which is a Microsoft tool and extension of SQL language. TSQL is mainly used for writing an entire program of block function procedure that defines how things need to be complete and creating an application in which each application sending transact query over SQL server and there is no interaction with the database. It executes as a whole block with the extension of SQL language.

blogpost

Pros of T-SQL

The advantages of T-SQL are....

1. Simple and easy

One of the things that make SQL a popular choice is that it doesn't require any substantial knowledge about coding and writing programs. SQL has some basic keywords such as SELECT, INSERT INTO, UPDATE, etc that can carry out tasks. Syntactical rules are also simple and easy to follow.

2. Faster Query Processing

SQL works at an efficient speed. Huge data can be processed in seconds! Querying, manipulating, and calculations on data with analytical queries in a relational database can be done in no time.

3. Standard Language

As already mentioned, SQL is a standardized structured query language approved by ISO and ANSI for relational databases. Its long, detailed, and established documentation overs years also stands as a strong plus point.

4. Portable

It is highly portable as used in PCs, servers, independent laptops having any operating system such as Windows, Linux, Mac, etc. It can also be embedded with other applications.

5. Highly Interactive

As it has simple commands for all purposes, it becomes an interactive language for its users. It is easy to understand and the commands are also understandable to the non-programmers.

Cons of T-SQL

The disadvantages of T-SQL are...

1. Poor Interface

SQL has a poor interface as it makes look everything very complex even when it's not! Due to its difficult interfacing, users find it difficult to deal with the databases.

2. Cost Inefficient

SQL Server Standard costs around $1,418/year. The high cost makes it difficult for some programmers to use it.

3. Partial Control

SQL doesn't grant complete control over databases to its users. This is due to some hidden business rules.

4. Security

Regardless of the SQL version, databases in SQL is constantly under threat as it holds huge amounts of sensitive data.

Differences Between T-SQL and Standard SQL

The first difference between SQL and T-SQL is the TOP keyword, which is used mainly in a SELECT statement. It indicates how many rows should be returned by a query in a result set. TOP is put after SELECT along with the number of rows to return. For example, the following query returns only the first 12 results:

SELECT TOP 12 Id, Name, Description 
FROM Products ORDER BY Name;

You don't find this clause in standard SQL—it is available only in MS SQL Server. You can learn more about how and when to use the TOP statement in MS SQL Server in the course "SQL Basics in MS SQL Server".

Another difference between SQL and T-SQL is in the syntax of the SUBSTRING function used to cut a substring from a given string input. In standard SQL the syntax of this function is:

SUBSTRING(str FROM start [FOR len])

In the MS SQL Server the syntax of the function is:

SUBSTRING(str, start, len)

In these functions, str is a given string to search, a start is a start number of a character (the first is 1) in a string from which the function will begin searching, and len is the length of the string to return.

These are only two examples of the differences between standard SQL and T-SQL, but you can learn more in this "SQL Basics in MS SQL Server" course and this "SQL Basics" course.

Conclusion

SQL is a base programming language, while T-SQL is derived from SQL. The choice of which database to use will depend on your project requirements.

If you wish to learn more about SQL, then check out our SQL certification course. The course will equip you with all you need to work with SQL databases and use them in your applications. From structuring your database correctly to authoring efficient SQL statements and clauses, managing your SQL database for scalable growth, and getting excellent work-ready training on SQL, it has a multitude of applications at work.

T SQL
0 VIEWS 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWS SHARE
Was this blog helpful?
techiio-price-plantechiio-price-plantechiio-price-plantechiio-price-plantechiio-price-plan
You must be Logged in to comment
Code Block
Techiio-author
Shuvhojit Deb
Full Stack Developer
Techiio-followerTechiio-follower
117 Blog Posts
0 Discussion Threads
Trending Technologies
15
Software40
DevOps46
Frontend Development24
Backend Development20
Server Administration17
Linux Administration26
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance