SQL Server Tutorial

SQL Server Comparison Operator In SQL Server, the comparison operators are used to test for equality and inequality. These operators are used…

SQL Server Management Studio (SSMS) MS SQL Server Management Studio is a workstation or a client tool which is used to connect…

How to Download and Install MS SQL Server This article gives a complete overview of how we can install and configure SQL…

How to find SQL Server Version A version is a specific form of something that varies from other forms of the same…

Restore a Database In SQL Server, you can restore a database very easily. To restore a database right click on the Databases…

SQL Server Unique Key Unique key is a constraint in SQL Server. This constraint ensures that we cannot enter duplicate values into…

Table Variable in SQL Server Table variables are a special part of the local variable that allows us to hold complete table…

SQL Server Rename Table When the table name is no longer relevant or no longer serves the purpose of creation, we can…

SQL Server Temp Table A temporary (temp) table in SQL Server is a special table that cannot be stored permanently on the…

Triggers in SQL Server A trigger is a set of SQL statements that reside in system memory with unique names. It is…