DATEDIFF(): How to get Difference between Two Dates?
DATEDIFF (): This function will return difference between two dates in any of the following datepart: Hours, day…
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 …
While working in Angular, some time we have large text but we want to show limited text. In that case we can use slic…
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…
We can download all type of file like CSV, Docx, PNG, JPG, PDF etc from FTP server in asp.net using c#. I have share…
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…
Some time we want to perform some action after particular interval of time. Ex. redirect to other page after 5 sec . …
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…
We can use SqlDatasourse to show data in Gridview data control. In this article we will learn how to do this.
Using Javascript or Jquery we can acheive this easily. This article is useful for beginners.
Error: Access to XMLHttpRequest at 'http://core/api/test/filter?id=0' from origin
In this article we will discuss how to bind multiple dropdown with different data from one XML. Its easy to bind sing…
In this article we will discuss how to populate dropdown with xml data. It is very basic article and may be useful for…