Category

SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

Image

Introduction SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

Read More

Image

Data Type in SQL Server

By using Data type We can easily identify what kind of information we are going to store in the table.

Read More

Image

SQL Statements and Database in SQL Server

SQL Statements used to communicate with database to perform specific tasks.

Read More

Image

Working With Table

Whenever we create a table that time we need to provide a table_name with column details such as name,data type and constraints.

Read More

Image

Alter,Where,Order By and SQL alias in SQL Server

When we are required to change the structure of the existing table that time we use Alter command.

Read More

Image

Operator in SQL Server

- Operators are used to performing operations on two or more operands.

Read More

Image

Like Operator in SQL Server

By using the Like operator we are able to find out specific patterns in a column.

Read More

Image

Constraint in SQL Server

It used to specify the rules for the data in a table.

Read More

Image

Foreign Key Constraint in SQL Server

Used to Prevent inserting invalid data into the column.

Read More