db operations

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

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…

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

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

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

SQL Server ROLLUP The ROLLUP clause in SQL Server is an extension of the grouping set operator. This article will give a…

SQL Server UNION Operator In SQL Server, the UNION operator is used to combine the result-set of two or more SELECT statements.…

SQL Server Row Number Row number is the most common ranking function used in SQL Server. The ROW_NUMBER() function generates a sequential…

MS SQL Server Select Database SQL Server select database specifies your database in which you want to create your table and further…