MS SQL Server LTRIM() Function
Sometime you may need to trim leading blank space character from your desired text in MS SQL Server. There is a function called LTRIM in...
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...