We can filter data in Dataset in asp.net C# using DataRow. We can use multiple filters in Dataview rowfliter to fil…

DATENAME() Function in SQL server: The DATENAME() function returns a specified part of a date. It returns nvarchar…

ALTER TABLE Statement in SQL: To add, delete, or modify columns in an existing table, we use ALTER TABLE statement…

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 …

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…

Function cannot be used to perform action that can modify data ex. Insert, Update & Delete.

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…