Sign up for Hasura Newsletter

What is MSSQL Server?

Introduction to MS SQL Server

MS SQL Server is a Relational Database Management System (RDBMS) database developed by Microsoft. A Relational database is based on a Relational Model architecture. The data is organized in tables(relations), and the tables are related to each other. Each table has rows and columns(attributes). MS SQL Server is a software product used to administer the database and retrieve information.

What is SQL and T-SQL

SQL (Structured Query Language) is a domain-specific language to manage data in an RDBMS. The scope of SQL includes data query, data manipulation, data definition, and data access control.

MS SQL Server has its proprietary query language called Transact-SQL or T-SQL to interact with MS SQL Server. You can run T-SQL queries via SQL Server Utility available in SQL Server Management Studio (SSMS) or via the sqlcmd utility.

Tools that use T-SQL

Some of the Microsoft tools that are used to run T-SQL commands are:

In this tutorial we will use SSMS on Windows Server 2019.

What is SQL Server Management Studio SSMS

SQL Server Management Studio (SSMS) is a management software for SQL Server database engine. An SSMS is a primary tool to connect and administer the SQL Server database engine and run Transact-SQL on the database.

Did you find this page helpful?
Start with GraphQL on Hasura for Free
  • ArrowBuild apps and APIs 10x faster
  • ArrowBuilt-in authorization and caching
  • Arrow8x more performant than hand-rolled APIs
Promo
footer illustration
Brand logo
© 2021 Hasura Inc. All rights reserved
Github
Titter
Discord
Facebook
Instagram
Youtube
Linkedin