How to Change a Column to Allow NULL in MS SQL Server
If you have a column in a SQL Server table that does not allow NULL values and you want to insert row(s) with NULL values,...
Excel is not updating cells values
Sometime you may see that your excel is not updating it’s cells values or excel formulas are not updating when dragging. You may be big...
How To Delete Objects in R
When we work in R, we have to create many objects. Sometimes we create objects for temporary purposes. In some certain situation, those temporary objects...
Top 10 Query in Different Databases
If you are working with Data, hope you are familiar with different databases. Professionally I have worked with Oracle, MySQL, Microsoft SQL Server, DB2 in...
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...
What is Training, Validation and Test Data Set
When you start working with data science and engineering you will hear three terms of sample data 1) Training Data Set, 2) Validation Data Set,...