There are several functions available in SQL Server to work with Date manipulation. We can use the DATEADD () function
Continue readingCategory: SQL
SQL Server IIF Function
SQL Server IIF Function:- SQL IIF function is the new built-in Logical function introduced in SQL Server 2012 and it
Continue readingSQL Server – Difference Between Clustered and Non-Clustered Indexes
An index can be best described as a pointer to data in a table. An index in a database is
Continue readingSQL Server SUBSTRING() Function
In SQL Server , the SUBSTRING functions allows you to extract a substring from a string that is varchar data-type.
Continue readingSQL Coalesce function in SQL Server
The SQL COALESCE function is used to handle NULL values and return the first, non-null value from the series of
Continue readingHow To Delete Duplicate Rows in SQL Server
Duplicate records in the database are old age problem that almost every organization has to deal with that.Duplicate may appear
Continue readingHow to Rename Column Name And Table Name In SQL Server
In this article we are going to show you,How to Rename Table Name and Column Name in SQL Server with
Continue readingHow To Convert STRING To INT In SQL SERVER
If the table column is in VARCHAR and contains all numeric values, then it can be obtained as an integer
Continue readingSQL indexes
What Is an Index? An index can be best described as a pointer to data in a table. An index
Continue readingHow to find week of the Year,start date and end date of the week in SQL Server
Below Script gives you three important details related to date using datepart() function. Current Week of the Year Start of
Continue reading