MS SQL Server Management Studio is a workstation or a client tool which is used to connect to and manage your SQL Server from a graphical interface instead of having to use the command line.

In order to connect to a remote instance of an SQL Server, you will need this or similar software. It is used by Administrators, Developers, Testers, etc.

The following methods are used to open SQL Server Management Studio.

First Method

Start → All Programs → MS SQL Server 2012 → SQL Server Management Studio

Second Method

Go to Run and type SQLWB (For 2005 Version) SSMS (For 2008 and Later Versions). Then click Enter.

When you first time use management studio, you will see something like this:

SQL Server Data types

Data types can be divided in three types:

String Types
Number Types
Date Types

String Types

Data Type	Description
char(n)	It is a fixed width character string. It can store maximum 8,000 characters.
varchar(n)	It is a variable width character string. It can store maximum 8,000 characters.
varchar(max)	It is a variable width character string. It can store maximum 1,073,741,824 characters.
text	It is a variable width character string. It can store maximum 2GB of text data.
nchar	It is a fixed width unicode string. It can store maximum 4,000 characters.
nvarchar	It is a variable width unicode string. It can store maximum 4,000 characters.
nvarchar(max)	It is a variable width unicode string. It can store maximum 536,870,912 characters.
ntext	It is a variable width unicode string. It can store maximum 2GB of text data.
bit	It allows 0, 1, or NULL values.
binary(n)	It is a fixed width binary string. It can store maximum 8,000 bytes
varbinary	It is a variable width binary string. It can store maximum 8,000 bytes
varbinary(max)	It is a variable width binary string. It can store maximum 2GB.
image	It is a variable width binary string. It can store maximum 2GB.

Number Types

Data type	Description	Storage
tinyint	allows whole numbers from 0 to 255	1 byte
smallint	allows whole numbers between -32,768 and 32,767	2 bytes
int	allows whole numbers between -2,147,483,648 and 2,147,483,647	4 bytes
bigint	allows whole numbers between -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807	8 bytes
decimal(p,s)	fixed precision and scale numbers.allows numbers from -10^38 +1 to 10^38 ?1.the p parameter indicates the maximum total number of digits that can be stored (both to the left and to the right of the decimal point). p must be a value from 1 to 38. default is 18.the s parameter indicates the maximum number of digits stored to the right of the decimal point. s must be a value from 0 to p. default value is 0	5-17 bytes
numeric(p,s)	fixed precision and scale numbers.allows numbers from -10^38 +1 to 10^38 ?1.the p parameter indicates the maximum total number of digits that can be stored (both to the left and to the right of the decimal point). p must be a value from 1 to 38. default is 18.the s parameter indicateas the maximum number of digits stored to the right of the decimal point. s must be a value from 0 to p. default value is 0	5-17 bytes
smallmoney	monetary data from -214,748.3648 to 214,748.3647	4 bytes
money	monetary data from -922,337,203,685,477.5808 to 922,337,203,685,477.5807	8 bytes
float(n)	floating precision number data from -1.79e + 308 to 1.79e + 308.the n parameter indicates whether the field should hold 4 or 8 bytes. float(24) holds a 4-byte field and float(53) holds an 8-byte field. default value of n is 53.	4 or 8 bytes
real	floating precision number data from -3.40e + 38 to 3.40e + 38	4 bytes

Date Types

Data Type	Description	Storage
datetime	It specifies a date and time from january 1, 1753 to december 31, 9999 with an accuracy of 3.33 milliseconds.	8 bytes
datetime2	It specifies a date and time from january 1, 0001 to december 31, 9999 with an accuracy of 100 nanoseconds.	6-8 bytes
smalldatetime	It specifies a date and time from january 1, 1900 to june 6, 2079 with an accuracy of 1 minute.	4 bytes
date	It is used to store a date only. It specifies a date from january 1, 0001 to december 31, 9999.	3 bytes
time	It is used to store a time only to an accuracy of 100 nanoseconds.	3-5 bytes
datetimeoffset	It is the same as datetime2 with the addition of a time zone offset.	8-10 bytes
timestamp	It stores a unique number that gets updated every time a row gets created or modified. the timestamp value is based upon an internal clock and does not correspond to real time. each table may have only one timestamp variable.

So, this brings us to the end of blog. This Tecklearn ‘SQL Server Management Studio and SQL Data Types’ blog helps you with commonly asked questions if you are looking out for a job in MS-SQL Server. If you wish to learn MS-SQL Server and build a career in Database domain, then check out our interactive, MS-SQL Server Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/ms-sql-server-training-and-certification-course/

MS-SQL Server Training

About the Course

Microsoft SQL Server training course is an online classroom training meant for developers to master the descriptive language to work for relational databases. Important topics included in this SQL course are SQL introduction, relational databases, queries, subqueries, joins, and unions. After completing this course, you will also become proficient in the theory of optimization, transactions, indexing, installing SQL Server, database administration, clustering, implementing programmability objects, designing and implementing database objects, managing database concurrency, and optimizing SQL infrastructure and database objects.

Why Should you take MS-SQL Server Training?

The average salary for Sql server developer ranges from approximately $88,666 per year for Database Developer to $115,811 per year for Senior SQL Developer. – Indeed.com
Wells Fargo, UPS, US Bank, Perspecta, Silicon Valley Bank, Mindtree Wipro, Infosys & many other MNC’s worldwide use MS SQL Server for their Database deployments.
According to Gartner, MS SQL Server is the market leader in the Relational Database with 18.5% market share globally.

What you will Learn in this Course?

Introduction to SQL

Various types of databases
Introduction to SQL
Installation Steps of MS-SQL Server
Overview of Microsoft SQL Server Management Studio
SQL architecture, client/server relation
Database types

Introduction to relational databases, basic concepts of relational tables

Working with rows and columns
Various operators used like logical and relational
Constraints, Primary Key and Foreign Key
Insert, Update, Delete, Alter

Working with SQL: Join, Tables, and Variables

SQL Operators and Queries
SQL functions
Creation of Table
Retrieval of Data from tables
Combining rows from tables using joins
Operators such as intersect, except, union, temporary table creation, set operator rules, table variables etc

Deep Dive into SQL Functions

Data Retrieval Language
Functions
Operators
Clauses
Sub-Queries
Correlated Sub-Queries

SQL Views, Functions

Sub-queries
Views
Indexes

Managing Data with Transact-SQL

Transact-SQL queries
Implementing functions and aggregating data
Determining the results of DDL statements on supplied tables and data

Cursor Management and Triggers

Cursors
Triggers
Types of Triggers

Stored Procedures and User Defined functions

Understanding of Stored Procedures
Key benefits of Stored Procedures
Studying user-defined functions

Deep Dive into User-defined Functions

Detailed study of user-defined functions
Various types of UDFs like Scalar, Inline Table Value, multi-statement Table
What is Rank Function? Triggers, when to execute Triggers?

SQL Optimization and Performance

Concepts of Concurrency and Locking behaviour
Usage of memory-optimized tables to solve issues
Examining and Troubleshooting of query plans
Performance management of Database instances
SQL server Performance Monitoring

Got a question for us? Please mention it in the comments section and we will get back to you.

648