DATENAME() Function in SQL server.
DATENAME() Function in SQL server: The DATENAME() function returns a specified part of a date. It returns nvarchar…
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 …
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 . …