Category: Data Engineering

InitCap Function in SQL Server

There is no InitCap function in SQL Server. Who are mainly experienced in Oracle but have to work in SQL Server he/she may be depressed...

Random Sampling in MS SQL Server

There are different ways of sampling data. Random sampling is one of the most popular and most easiest way of sampling. But before using the...

Correlated Update in MS SQL Server

Updating data of one table by data of another table is very much important in Data Engineering. Which table need to be updated is called...