SQL Query to Get Month wise Data, Year wise Data

Introduction

In this SQL Server article I will explain how to write query to get monthly (month wise) data or year wise data from database.

Description

In previous articles I explained Query to get Exclude weekends in SQL Query, While Loop Example in SQL Server, Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to write query to get month wise data or year wise data from database in SQL Server.

How to Exclude Weekends in SQL Query or Get Records Without Weekends

Introduction:

In this SQL Server article I will explain how to write query to get records Exclude weekends data or without weekends data in SQL Server.

Description:

In previous articles I explained insert single quote data in database, DateAdd function Example, Pass table as parameter to procedure, difference between function and stored procedures, joins in SQL Server and many articles relating to SQL Server. Now I will explain how to write a query to get records without weekend’s data in SQL Server.

SQL Server Insert Data with Apostrophe/Single Quote in Database

Introduction

In this SQL Server article I will explain how to insert single quote or apostrophe data in database.

Description

In previous articles I explained While Loop Example in SQL Server, Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to insert single quote or apostrophe data in SQL Server.

SQL Server Nested WHILE Loop Example

Introduction

Here I will explain how to use nested while loops in SQL Server with example.

Description

In previous articles I explained While Loop Example in SQL Server, Break or Exit while loop in SQL Server, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server. Now I will explain how to use nested while loops in SQL Server.

SQL Server EXIT or BREAK from WHILE Loop with Example

Introduction

Here I will explain how to exit from while loop in SQL Server or how to break from while loop in SQL Server with example.

Description

In previous articles I explained While Loop Example in SQL Server, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to break or exist while loop in SQL Server with example.

SQL Server While Loop Example with stored procedure

Introduction

Here I will explain how to use while loop in SQL Server stored procedure with example.

Description

In previous articles I explained Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to use while loop in SQL Server stored procedure with example.

SQL Query to Find First and Last Day of Current Month or Previous Month

Introduction:

Here I will explain how to write query to get or find first and last day of current month or previous month in SQL server.

Description:

In previous articles I explained DateAdd function Example, Pass table as parameter to procedure, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain query to get first and last day of current month in SQL server.

SQL Server DATEADD Function Example to Add or Subtract Dates

Introduction: 

In this article I will explain how to use DATEADD function to add or subtract specified time interval from dates in SQL Server.

Description:

In previous articles I explained Substring function Example, SQL Query to remove first and last character from string and many articles relating to SQL Server. Now I will explain how to use DATEADD function to add or subtract specified time interval from dates in SQL Server.

SQL Server Get Created, Last Modified date of Stored Procedure or Table

Introduction:

In this article I will explain how to find or get last modified date and created date of stored procedure or table in SQL server.

Description:

In previous articles I explained difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to get last modified date or created date of stored procedure or table in SQL server.

SQL Server Retrieve Data from Multiple Tables using Joins

Introduction:

In this article I will explain how to retrieve data from multiple tables in sql server.

Description:

In previous post I explained Difference b/w functions and stored procedures, Pass table as parameter in SQL Server 2008, differences between char, varchar and nvarchar, difference between tinyint,smallint,int,bigint and many articles relating to SQL Server. Now I will explain how to retrieve data from multiple tables in SQL Server.

SQL Server - Differences between Functions and Stored Procedures

Introduction:

Here I will explain the difference between stored procedure and function in SQL Server.

Description:

In previous posts I explained difference between Left Join and Left Outer Join, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between stored procedure and function in SQL Server.

SQL Server 2008- Pass Table as Parameter to Stored Procedure Example

Introduction:

In this article I will explain how to pass table as parameter to stored procedure in SQL Server 2008.

Description:

In previous articles I explained Convert Rows to Columns, Query to get data between two dates, Query to get duplicate records count, Query to remove duplicate records and many articles relating to SQL Server. Now I will explain how to pass table as parameter to stored procedure in SQL Server 2008.

SQL Server- Difference Between Full Outer Join and Cross Join

Introduction:

Here I will explain what is the difference between cross join and full outer join in SQL Server.

Description:

In previous posts I explained difference between Left Join and Left Outer Join, difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between cross join and full outer join in SQL Server.

SQL Server- Difference Between Left Outer Join and Right Outer Join

Introduction:

Here I will explain differences between left outer join and right outer join in SQL Server.

Description:

In previous posts I explained difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between left outer join and right outer join in SQL Server.

SQL Server- Difference Between Left Join and Left Outer Join

Introduction:

Here I will explain the difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain the difference between left join and left outer join in SQL Server.

Actually this one is very simple question but many of beginners are asking the same question that’s why I decided to write an article on it. Basically there is no difference between LEFT JOIN and LEFT OUTER JOIN both are same. Whenever we use LEFT JOIN keyword in SQL Server that is the LEFT OUTER JOIN only  

Difference between Left Join,Right Join,Cross Join,Inner Join,Full Outer Join,Self Join in SQL Server

Introduction:

Here I will explain the differences between Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain the differences between Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server. To know about the difference between all the joins check this article

Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server

Difference Between LEN and DATALENGTH Functions in SQL Server

Introduction:

In this article I will explain differences between Len() and DataLength() functions in sql server.

Description:

In previous post I explained differences between char, varchar and nvarchar, difference between tinyint,smallint,int,bigint and many articles relating to SQL Server. Now I will explain differences between Len() and DataLength() functions in SQL Server.

How to Convert Rows to Columns in SQL Server Without Using Pivot

Introduction:

Here I will explain how to convert row values to column values without using pivot in SQL Server.

Description:

In previous articles I explained Query to get duplicate records count, Query to remove duplicate records and many articles relating to SQL Server. Now I will explain how to write a query to convert row values to column values without pivot in SQL Server. In database I have one table UserInformation that contain data like as shown below

SQL String or Binary Data Would be Truncated. The Statement has been Terminated

Introduction: 

Here I will explain how to solve the problem of “string or binary data would be truncated. The statement has been terminated.” in sql server. 

Description:

One day I am trying to insert data into one table using SQL queries at that time I got error like “String or binary data would be truncated. The statement has been terminated.” Actually this problem because of I declared column datatype varchar(25) but I am inserting data more than 25 characters in that column. To solve this problem I modified column datatype varcha (25) to varchar(50)

SQL Server - Query to Get Data between Two Dates in SQL Server

Introduction:

Here I will explain how to write a SQL query to get data between two dates in SQL Server.

Description:

In previous articles I explained many articles relating to SQL Server. Now I will explain how to write a query to get data between two dates in SQL Server. In database I have one table UserInformation that contain data like as shown below