Date and Time Format Using Convert Function in MS SQL Server
MS SQL Server provides has a number of built-in options to format a date and time in different ways. Here are the list of built-in...
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,...
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,...