SQL Server 2017 Community Technology Preview 2.0 is available

Microsoft announced a preview of SQL Server 2017.  You can download the preview version from here. It will available for both windows and Linux. This preview added some new capabilities & features.

Read More

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

SQL Server 2016 will available on June 1st

Microsoft's announced official release date for  SQL Server 2016 will available on June 1st. SQL Server 2016 is a high scale data platform for your most injuctively authorizing applications and insights on your data on any contrivance.

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