DATEPART(): This function is used get a particular part of date i.e. Day, month, year. It will return the part…

DATEDIFF (): This function will return difference between two dates in any of the following datepart:   Hours, day…

DATEADD(): Functions is used when we want to get date by adding days or month or year in given date. It will displa…

In this article we will discuss various date related functions available in SQL, which are very useful when we need …

ROW_NUMBER ()   function is used to generate sequence number for each row in given result set as per partition. For…

In previous post, we have discussed how to change schema of tables(single & multiple). Sometime we have two types…

Sometimes We try to run database script of database from one server to another server, without removing schema suffix…

In this article, we will learn how to find sum of column’s value. This will be very helpful in situation where we calc…

We use various constraints in database, which are very helpful to manage database.

We can delete tables from database one by one by using Query as well as using GUI. Some time we need to delete all ta…

When we want to return table as a result, then we can use table valued functions. User defined Table Valued function…

User defined scalar function returns single value as a result of function. We can return any data-type value from func…

We can use SqlDatasourse to show data in Gridview data control. In this article we will learn how to do this.

In this article I will explain how to perform all crud functions using Gridview data Control i.e. insert, update, del…

Introduction: In this article I will explain how to copy full data of one table to another new table in SQL datab…