RANK() Function in MS SQL Server with Examples
The RANK() function is one of the ranking functions in T-SQL used to assign a rank to each row within a partition of a result...
ROW_NUMBER() Function in MS SQL Server with Examples
Sometimes you may need to add row number or serial number with your desired outcomes in MS SQL Server. There is a function called ROW_NUMBER() in...
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...