Scribd
Upload
13 views2 pages

MS SQL Server Installation & Data Types Guide

The document provides a step-by-step guide for installing MS SQL Server and explains the differences between Char and Varchar data types, highlighting their fixed and variable lengths respectively. It also outlines the types of SQL commands, including DDL, DML, DCL, TCL, and DQL, which are used for various database operations. Additionally, it describes NVarchar and Nchar data types, emphasizing their fixed and variable lengths for Unicode characters.

Uploaded by

MOHD Adil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views2 pages

MS SQL Server Installation & Data Types Guide

The document provides a step-by-step guide for installing MS SQL Server and explains the differences between Char and Varchar data types, highlighting their fixed and variable lengths respectively. It also outlines the types of SQL commands, including DDL, DML, DCL, TCL, and DQL, which are used for various database operations. Additionally, it describes NVarchar and Nchar data types, emphasizing their fixed and variable lengths for Unicode characters.

Uploaded by

MOHD Adil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

--1.

Install MS SQL Server

-- Go to official microsoft website and download ms sql server installation (choose developer)

-- launch the setup file

-- select basic or custom for advance options

--- accept license terms , choose installation path and configure server settings

--click on install and wait for process to finish

-- use sql server management studio to connect to your sql and start managing databases

--2. Give the difference between Char and Varchar data type.

-- char stands for character .

-- it is a fixed length datatype that is used to store text

--if you define char(10) and store 5 still sql reverese the space 10charcter

-- varchar:

-- varchar stands for variable character

--it is varaible length datatype to store text

-- if you define varachar(50) and store 5 character , sql wll only use space for 5 character not all 50

--3. Explain the types of SQL Commands.

-- sql commands are intructions to communicate with database

-- they are used to create table, insert data,, update records, delete records and many more

-- DDL - data definition language -> create , drop, alter

-- DML -- data manipulation language -> insert , update , delete , select

-- DCL -- data control language --> grand , revoke

-- TCL --> transaction control language -> commit,rollback

-- DQL -> data query language -> select

--4. Explain NVarchar and Nchar.

-- nchar -> (national character)

-- it is fixed length unicode character datatype


-- if you declare nchar(10) it will store 10 charcter

--- good when all the values have the same length

-- nvarchar: (national varaible character)

--it is a variable unicode characte datatype

-- if you declare nvarchar(50) , store 10 character it uses only that space it needs

-- more flexible than nchar

You might also like