Latest posts on "SQL"

Datediff Sql Compare two dates

5 September 2016

In this article, I will explain how to compare two dates and gets number of days using Datediff in SQL server.

Entity framework connection string example

29 August 2016

To get the SQL connection string from entity framework using DbConetext edmx file. In this example I will show you with example.

Sql server isnull example?

8 July 2016

In this article, I describe How to use NULLIF in sql server. As we knows nullif clause used to check the value is null or not. If the value is null then we define some default value.

How to create while loop SQL server?

7 May 2016

In this article we will discuss, How to create while loop SQL server We will be using Employee table. Below example we need to insert 1000 products to a item table using while loop.

How to find your Current bank balance using SQL query?

23 March 2016

In this section, I explain how to find your bank balance using sql query. This questions asked by many interviewer, so please do this practice before go to interview.

Page 2 of 3