MS SQL Server DENSE_RANK() Function with Examples
The DENSE_RANK() function is a ranking function in SQL Server that assigns a rank to each row within a partition of a result set, like...
How To ENABLE a PRIMARY KEY in MS SQL Server
Sometimes you need to enable your disabled primary key in MS SQL Server. You can enable a primary key using the ALTER INDEX statement in...
How To DISABLE a PRIMARY KEY in MS SQL Server
Sometimes you may need to disable your primary key in MS SQL Server. You can delete your primary key directly but I recommend if you...
How to DROP a PRIMARY KEY in MS SQL Server
Sometimes you may need to drop or delete primary key of a table in MS SQL Server. You can drop a primary key in SQL...
How to Create a PRIMARY KEY in SQL Server
A primary key is a column or a group of columns that uniquely identifies each record in a table. You can create a primary key...
What is the Equivalent of DESCRIBE table in MS SQL Server
Working with a table sometimes we need to know the structure of the table i.e variable_name, variable_type, variable_size, constraint etc. In Oracle we use DESCRIBE...