Get Number of Active Connections to Database in SQL Server

Introduction

Here I will explain how to get or find number of active connections to database in SQL Server. 

Description

In previous articles I explained Read XML file data using SQL Server, Joins in SQL Server, Get Latest Unique Records by count in SQL Server, Insert data with apostrophe in SQL Server, Convert Rows to Columns in SQL and many articles relating to SQL Server.  Now I will explain how to get or find number of active connections to database in  SQL Server.

SQL Sever- Reading XML Data File using SQL Query Example | Read XML Data Type in SQL Server

Introduction:

Here I will explain how to write a query to read xml data file or read xml data type with simple example using SQL Server.

Description:

In previous articles I explained Pass XML file as a parameter to stored procedure, read xml node values and bind data to gridview, how to insert and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to write a query to read xml data in SQL Server.

Pass XML as Parameter from C# to SQL Stored Procedure in VB.NET

Introduction:

Here I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

Description:

In previous articles I explained read xml node values and bind data to gridview, how to insert and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

SQL Query to Get Latest Unique Records by Date

Introduction:

Here I will explain how to write query to get latest or recent records but unique records in SQL Server.

Description:

In previous articles I explained joins in SQL Server, Get Records without weekends, SQL Query Get Month Wise Data, difference between function and stored procedures, and many articles relating to SQL Server. Now I will explain how to write a query to get latest or recent records but unique records in SQL Server.

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