Sample Stored Procedure example Stored procedure is a bunch of SQL statements which forms a logical unit and execute for a particular task and it’s used to encapsulate set of operations or queries to execute on database server. Once stored … Continue reading
Add Datetime Default Value SQL To create a table with default date time value, you will have to use getdate() as column default value. Be-careful while putting default value that column should not be not null by default. Please have … Continue reading
Select statement inside Case count condition While working with database many time requirement comes to get data using select query based on certain condition and one of these condition is to compare and get data joining two table and put … Continue reading
There are many different mongoDB management tools available. I found Robomongo is easy to use.
This demo will show you how to create database mongoDB . Please follow below steps:
To install mongoDB please follow below steps: