Monday

MSSQL tutorials full detail by jani

Today i tell you

What is a MSSQL? What is MSSQL capable of? What is MSSQL used for?

What is a MSSQL?

MSSQL is short for Microsoft SQL Server. It is a relational web hosting database that is used to store web site information like blog posts or user information.
MSSQL is the most popular type of database on Windows servers.
It is not free but it has many advanced features that make it suitable for businesses.

What is MSSQL capable of?

In basic terms, an MSSQL database is capable of storing any type of that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time. You will use SQL statements to accomplish all of this. In more technical terms, most versions of MSSQL have the following features:
*.Buffer management
*.Logging and Transaction
*.Concurrency and locking
*.Replication services
*.Analysis services
*.Notification services
*.Integration services
*.Full text search service
*.Stored procedures
*.Triggers
*.Views
*.Sub-SELECTs (i.e. nested SELECTs)

What is MS SQL used for?

MSSQL is the database of choice for web applications on a Windows platform (using .NET or ASP).
These languages make is extremely easy to connect to a MSSQL database. It is also used for many popular content management systems and other scripts.