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 SQL(Structured Query Language) and T-SQL(Transact-SQL).
SQL (Structured Query Language) and T-SQL (Transact-SQL) are both used to interact with relational databases. SQL is the standard query language common across all RDBMS platforms, while T-SQL is Microsoft's proprietary procedural extension to SQL used specifically with SQL Server. SQL (Structured Query Language) SQL is a non-procedural, declarative language used by database engines to create, modify, and query databases. You tell the database what you want, not how to get it. SQL is standardized by ANSI/ISO and is common across RDBMS platforms like MySQL, PostgreSQL, Oracle, and SQL Server. Example -- Standard SQL: simple ...
Read MoreDifference 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 More