SQL Server is Relational Database Management System developed by Microsoft to store and retrieve data.
SQL stands for Structured Query Language. SQL is basically Relational Database language which is used to create, manipulate and access the database
create, alter, drop, truncateDML (Data Manipulation Language)
insert, update and deleteSelect
Select command is used to retrieve data from database.DCL (Data Control Language)
There are many data types availble in SQL Server and some of these are as follows :-Numeric
int(4 bytes), bigint(8 bytes) , smallint (2 bytes) and tinyint(1 byte)Floating Point Numeric
Float(size depends on value) , Real (4 bytes)Character String
Char, Varchar, Text
SQL Server Tutorial. In this sql server tutorial, I have covered sql topics like insert, update, delete, select, Constraints, Aggregate function, like operators, group by, order by, case, range, top, join, stored procedure, triggers, xml data etc with example and queries. I have also shared Frequently asked SQL Interview Questions with Answers. In this Tutorial you will also get Practice Sheets and QUIZ Questions with Answers.