Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
T-SQL Articles
Found 3 articles
Difference Between T-SQL and PL-SQL
In this post, we will understand the difference between T-SQL and PL-SQL.T-SQLIt is a Microsoft product.It is known as Transact Structure Query language.It gives a high degree of control to the developers/programmers.It works its best, and provides good performance with Microsoft SQL server.It is easy.It is simple to understand.It allows the insertion of multiple rows into a table.This is done with the help of the ‘BULK INSERT’ statement.The ‘SELECT INTO’ statement is used in T-SQLIn this, the ‘NOT EXISTS’ clause can be used with the ‘SELECT’ statements.PL-SQLIt is an Oracle product.It is known as Procedural Language Structural Query Language.It is ...
Read MoreDifference Between SQL and T-SQL
In this post, we will understand the difference between SQL and T-SQL.SQLIt is a non-procedural language.Relational databases use SQL.It stands for structured query language.It uses query to view and manipulate data.DML and DDL operations are used- Data manipulation language, and data definition language.It is considered as an open-source language.It helps in the manipulation of data and data controlling.Transfer of data happens one by one when SQL is used.T-SQLIt is a Microsoft product.It is known as Transact Structure Query language.It gives a high degree of control to the developers/programmers.It works its best, and provides good performance with Microsoft SQL server.It is ...
Read MoreDifference between SQL(Structured Query Language) and T-SQL(Transact-SQL).
SQLSQL, Structured Query Language is a non-procedural language and is used by database engines to interpret SQL queries to create/modify/access the database elements.T-SQLT-SQL, Transact-SQL, is a procedural extension to SQL, used by SQL Server. It is similar to PL/SQL of Oracle.Following are the important difference between SQL and T-SQL.Sr. No.KeySQLT-SQL1TypeSQL is non-procedural by nature.T-SQL is procedural by natue.2MethodsSQL provides data manipulation and controlling functions.With T-SQL, we can write own procedures, functions with local variables.3ProprietarySQL is open to use and is common across RDBMS softwares.T-SQL is specific to SQL Server and is proprietary.4Query orderMultiple querires are submitted one by one.Using T-SQL, ...
Read More