---
title: "What SQL language is used in SSMS?"  
description: "What SQL language is used in SSMS?"  
author: "Revati S Misra"  
published: 2023-08-27  
updated: 2023-08-28  
canonical: https://www.mindstick.com/forum/159676/what-sql-language-is-used-in-ssms  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql"]  
reading_time: 2 minutes  

---

# What SQL language is used in SSMS?

What [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [language](https://www.mindstick.com/startup/28/preply-the-fast-growing-platform-transforming-language-learning) is used in [SSMS](https://www.mindstick.com/forum/159672/what-are-the-benefits-of-ssms)?

## Replies

### Reply by Aryan Kumar

The SQL language used in SSMS is Transact-SQL (T-SQL). T-SQL is an extension of the ANSI SQL standard that is used to interact with Microsoft SQL Server databases. It includes additional features that are specific to SQL Server, such as stored procedures and triggers.

SSMS is a graphical user interface (GUI) tool that makes it easy to create, manage, and administer SQL Server databases. It includes a query editor that allows you to write and execute T-SQL queries.

Here are some of the features of T-SQL:

- Data definition language (DDL): Commands to create, alter, and drop database objects such as tables, views, and stored procedures.
- Data manipulation language (DML): Commands to insert, update, delete, and select data from tables.
- Transaction control language (TCL): Commands to manage transactions, such as starting, committing, and rolling back transactions.
- Data control language (DCL): Commands to manage user access to databases, such as granting and revoking permissions.
- Stored procedures: Reusable blocks of code that can be called from within other T-SQL statements.
- Triggers: Events that are fired when certain conditions are met, such as when a row is inserted or deleted from a table.

If you are new to SQL, I recommend that you start by learning the basics of ANSI SQL. Once you have a good understanding of ANSI SQL, you can then learn about the additional features of T-SQL.


---

Original Source: https://www.mindstick.com/forum/159676/what-sql-language-is-used-in-ssms

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.