How to get a list of all weekdays between the given date range in SQL?

In this article I am going to discuss How to get all week days between given date range in SQL? Please check below code to get all weekdays  between given date range

Read More

Restore Database in SQL Server using SQL Query

In this article I will explain How to restore Database from .bak or.Mdf file in SQL Server using SQL Query. Please use following SQL queries for restoring the database.

Read More

How to use try catch statement in Stored Procedure?

We can use Try Catch Statement in our Stored procedure to handle error. In SQL there are no finally block like in C#. Let's start discussing it with an example.

Read More

Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT

In this article we are going to discuss difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT.  These functions are used to get last inserted rows identity(primary key value) in the table. Let's discuss it in more detail.

Read More

Use of Charindex Function in SQL with an example

In this article We will discuss How to use Charindex Function in SQL Server. It is utilized to hunt down particular keywords or sub-string in string and gives back to its beginning position of the match string. In the event that if no word found, then it will return 0.

Read More