ttmind

Main Navigation

ttmind
  • jim-jams
  • Tech
  • Positive
Login

Login

Facebook Google

OR

Remember me Forgot password?

Don't have account? Signup here.

Sort by Categorys

.Net

PHP

Java

JavaScript

Database

Server

Client Side

Tools

Artificial Intelligence

Cloud

Hybrid Development

Event

Smart City

Education

Security

Scrum

Digital Marketing

APP Development

Business

Internet

Simulation

Art

Network

Microservices

Architecture

Technology

Leadership

    Top Articles

  • How Does Social Media Bring People Together?
    TTMind Author
  • How to read appSettings JSON from Class Library in ASP.NET Core
    Anil Shrestha
  • Printing Support In Asp.Net Core
    TTMind Author
  • HOW TO EXTRACT TEXT FROM IMAGE USING JAVASCRIPT (OCR with Tesseract.js)?
    Prakash Pokhrel
  • Images Upload REST API using ASP.NET Core
    Prakash Pokhrel
  • Related Topic

  • Importance of database Constraints
  • Real life example of functional dependency, multivalued dependency, trivial functional dependency and non-trivial functional dependency.
  • MongoDb With Asp.Net Core Web API
  • DBMS and most popular DBMS Software in 2019
  • Creating .NET Core Console Application with NoSQL- MongoDB At Back-end
  • Tech
  • About Us
  • Contact Us
  • TechHelp
  • PositiveHelp
  • Jim-Jams Help
  • Terms & Conditions

© Copyright ttmind.com

Main Content

Transact-SQL(T-SQL) : Difference from SQL and PL/SQL?

Database SQL Language about 7 years ago || 11/21/2018 || 3.7 K View

  • Hide

Transact-SQL(T-SQL) is an extension of SQL developed for interacting with relational databases.

T-SQL is the product of Microsoft which expands on the SQL standard to include procedural programming.

It is the Microsoft’s implementation of SQL which can be used with Microsoft SQL Server and Azure SQL Database. It furthermore includes various extra features in comparison to regular SQL which includes procedural programming, local variables, data processing, mathematics, string processing ,etc. T-SQL is a programming language to Microsoft’s SQL database like PL/SQL is to Oracle database. All the communication between the application and SQL Server takes place with Transact-SQL statements.

Features:

Now, some of the features of T-SQL are listed below:

  1. Increased Programmability using Procedural Programming
  2. String Processing, Mathematics, Date Processing, etc
  3. Large no of built in functions
  4. Provides a built-in, interpreted and OS independent programming environment
  5. Local Variables.
  6. DELETE and UPDATE statements that can be changed
  7. BULK INSERT Statement which allows to import directly a data file into the database.

Difference between SQL, PL/SQL and T-SQL:

SQL: Stands for Structured Query Language which is used for communicating with SQL. It is an standard language for manipulating and retrieving data in relational database .

PL/SQL : It is combination of SQL along with a block of programming language which allows the developers to combine the features of procedural programming with SQL statements . It can execute a block of statement at a time using single command. It is an extension of SQL. It is a product of Oracle.

T-SQL: Already discussed above.

Applications that generate Transact-SQL:

  1. Office Productivity  Applications
  2. GUI database applications
  3. Business applications storing data in SQL Server
  4. DataWarehouse where data is extracted from Online Transaction Processing Systems(OLTP)

Example:

Creating a table:

CREATE TABLE tbl_Students (
	SId int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	StudentName nvarchar(255) NOT NULL,
	ActiveFrom date
);

Creating a Stored Procedure in Microsoft SQL Server:

/*  Getstudentname is the name of the stored procedure*/

Create  PROCEDURE Getstudentname
(
@studentid INT                   --Input parameter ,  Studentid of the student 
)
AS
BEGIN
SELECT Firstname+' '+Lastname FROM tbl_Students WHERE studentid=@studentid 
END

Also Read:Singleton Design Pattern in C#

For more detail:T-SQL Wikipidea

  • 0
  • 0
  • 0
    • Facebook
    • Twitter
    • Google +
    • LinkedIn

About author

Binod  Bhandari

Binod Bhandari

Life is not just about thrieving but all about living.

Reset Your Password
Enter your email address that you used to register. We'll send you an email with your username and a link to reset your password.

Quick Survey