Author : HASSAN MD TAREQ

Do you know? T-SQL is Turing complete

Terminology

RDBMS

Scheme

The term “schema” refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.These integrity constraints ensure compatibility between parts of the schema.

The schema in a relational database refers to the tables, fields and also the existing relationship between the fields and tables

A database schema is a collection of metadata that describes the relations in a database. A schema can be simply described as the “layout” of a database or the blueprint that outlines the way data is organized into tables.

Database schema == interface

Collation

Collation determines how your data is sorted and compared. It’s very often important with regards to internationalization, e.g. how do you sort japanese kanji?

If you google collation and sql server you’ll find plenty of articles discussing it.

T-SQL

Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.

GO

You can change batch seperator keyword from GO to anything in SSMS (i.e. FOO) Batch seperator in SSMS

Square Brackets - []

Setup database

Now restore sample database (i.e. AdventureWorks2017.bak) using SSMS

Step-1

Restoring sample database using ssms Step 1

Step-2

Restoring sample database using ssms Step 2

Step-3

Restoring sample database using ssms Step 3

Step-4

Restoring sample database using ssms Step 4

Step-5

Restoring sample database using ssms Step 5

Step-6

Restoring sample database using ssms Step 6