Saturday, 23 January 2016

Introduction of SQL Server

SQL Server each & RDBMS product which was designed & developed by the Microsoft company in 1989.
SQL Server is a backed tool which will tool developed backend application
SQL Server will see each and every application which is used on 1st storing some business relation organization information. SQL Server will run and install Windows Operating System only.
SQL Server is a complete platform independent.
The Platform is nothing but the combination of a processor and operating system. 

These are two types:
  •      Platform Independent: Platform Independent is nothing but to support to any processor to any operating system.
  •     Platform Dependent: Platform Independent is nothing but to support to any processor to only one operating system.
SQL Server will provide both GUI facilities, i.e. the user will perform the database operation by using icons without the remember queries.

The first version of SQL Server 1.0 & It was released in 1989.


Working with SQL Server:


SQL Server is a collection of database where as database is a collection of objects like tables, views, functions etc.


Data Type in SQL Server:

Data Types in an attributes which will specify what type of data inserting into table by the users:
Integer Data Types. 
Decimal Data Types.
Money And Currency Data Types.
Date and Time Data Types.
Character Data Types.
Binary Data Types.
Special and Other Data Types.


 

No comments:

Post a Comment