keys constraints and indexes

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

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…

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

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…

SQL Server STUFF() Function This article will describe a complete overview of the STUFF function in SQL Server. Most of the DBA…

SQL Server Substring SUBSTRING is a SQL Server built-in function that allows us to extract a specific substring from any given string…

SQL Server SUM() Function The SUM() function in SQL Server is a type of aggregate function. We use this function to calculate…

SQL Server Synonym An alias or alternative names can be given to any of the database objects like a table, view, stored…