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

ExecuteReader ExecuteNonQuery ExecuteScalar Examples in Asp.NET when to use what to use in C#.NET,VB.NET

Introduction:

In this article I will explain executereader executenonquery executescalar examples when to use what in asp.net using C#.net and VB.NET.

Description:

If you want to know which command object needs to be used in different situations for that you need to check this article

Differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net

If you want to know about each sqlcommand object check below articles

ExecuteReader Example in Asp.Net using C#,VB.NET

Introduction:

 

In this article I will explain ExecuteReader example in asp.net using C#.net and VB.NET. 

Description:

In previous post I explained ExecuteScalar Example, ExecuteNonQuery Example and differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net. Now I will explain ExecuteReader concept with one example in asp.net using C#.net, VB.NET. 

ExecuteReader

Execute Reader will be used to return the set of rows, on execution of SQL Query or Stored procedure using command object. This one is forward only retrieval of records and it is used to read the table values from first to last.

ExecuteScalar Example in Asp.Net Using C# and VB.NET

Introduction:

In this article I will explain executescalar example in asp.net using C#.net and VB.NET.

Description:

In previous post I explained ExecuteNonQuery Example and differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net. Now I will explain ExecuteScalar concept with one example in asp.net using C#.net, VB.NET.

ExecuteScalar

Execute Scalar will return first row first column value i.e. it will return single value and ignore other values on execution of SQL Query or Stored procedure using command object. It’s very fast to retrieve single values from database.

ExecuteNonQuery Example in Asp.Net Using C# and VB.NET

Introduction:

In this article I will explain executenonquery example in asp.net using C#.net and VB.NET.

Description:

In previous post I explained differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net. Now I will explain ExecuteNonQuery concept with one example in asp.net using C#.net, VB.NET.

ExecuteNonQuery

ExecuteNonQuery method will return number of rows effected with INSERT, DELETE or UPDATE operations. This ExecuteNonQuery method will be used only for insert, update and delete, Create, and SET statements.

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar

Introduction:

In this article I will explain differences between executereader, executenonquery and executescalar in asp.net.

Description:

In previous posts I explained difference between Len and DataLength functions, difference between int,tinyint and bigint and differences between char, varchar and nvarchar in SQL Server. Now I will explain difference between executereader, executenonquery and executescalar in asp.net

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.

JQuery Textbox with Clear Button | Clearable Textbox With JQuery Plugin

Introduction:

Here I will explain how to use JQuery to implement clearable textbox or textbox with clear button in JQuery using asp.net.

Description:

In previous article I explained Generate thumbnails from youtube video, Generate thumbnails from images using JQuery and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to create or implement textbox with clear button using JQuery in asp.net.

How to Send Gridview in Email Body in Asp.Net Using C#, VB.NET

Introduction:

In this article I will explain how to send Gridview as email body in asp.net using C# and VB.NET.

Description:

In previous article I explained Send HTML file as Email body in asp.net, Send Mail in asp.net, Send mail with images using gmail credentials, Send mail with attachment in asp.net and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to send Gridview as email body in asp.net using C# and VB.NET.

How to Send HTML Page As Email Body in Asp.Net Using C#.NET,VB.NET

Introduction:

In this article I will explain how to send html page as email body in asp.net using C# and VB.NET.

Description:

In previous article I explained Send Mail in asp.net, Send mail with images using gmail credentials, Send mail with attachment in asp.net and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to send html page as email body in asp.net using C# and VB.NET.

JQuery Show Large Image Preview When Hover On Link In Asp.Net

Introduction:

In this article I will explain how to show large image preview when hover on link or image using JQuery in asp.net.

Description:

In previous article I explained Generate thumbnail from images in asp.net, Generate thumbnails from YouTube videos using JQuery and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to show large image preview when hover on link or image using JQuery in asp.net.

Generate/Create Thumbnails From Images in JQuery using Asp.net

Introduction:

In this article I will explain how to create or generate thumbnails from Images in JQuery using asp.net.

Description:

In previous article I explained Generate thumbnail from images in asp.net, Generate thumbnails from YouTube videos using JQuery and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to generate or create thumbnails from Images using JQuery in asp.net.

Generate/Create Thumbnails From YouTube Video in JQuery Using Asp.net

Introduction:

In this article I will explain how to create or generate thumbnails from YouTube videos in JQuery using Asp.net.

Description:

In previous article I explained Generate thumbnail from images in asp.net and many articles relating to JQuery, asp.net, SQL Server etc. Now I will explain how to generate or create thumbnails from YouTube videos using JQuery in asp.net.

To generate thumbnails from YouTube videos we can use YouTube API URL that would be like this

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

Lost My PAN Card How to Apply For New One | Change Details in PAN Card

Introduction:

In this article I will explain how to apply for new pan card if pan card lost and how to make changes or corrections in pan card.

Description:

In previous articles I explained some of internettips like Setup DNS Server, Create desktop shortcut key to lock computer/laptop etc. Now I will explain how to change details in your pan card and how to apply for new pan card if old one lost.

Generally many of them will face problem like lost pan card or getting pan card with wrong details etc. After seen all these problems I realized that it’s better to write article to show how to get new pan card if existing one lost or how to make changes in pan card if any wrong details printed on card.

jQuery Highlight Gridview Row When CheckBox is Checked in Asp.Net

Introduction:

In this article I will explain how to highlight gridview rows when checkbox is checked or selected in asp.net using JQuery.

Description:

In previous article I explained select/deselect checkboxes in gridview using JQuery, select header checkbox when all child checkboxes selected in JQuery and many articles relating to JQuery. Here I am using select header checkbox when all child checkboxes selected in JQuery concept to highlight gridview row when checkbox is checked in JQuery.

If we want to highlight checkbox selected gridview rows using JQuery we need to write the code like this

Validate DropdownList Using JQuery in Asp.Net

Introduction: 

Here I will explain how to validate dropdownlist using JQuery using asp.net.

Description:
  
In previous articles I explained validate checkboxlist in JQuery, validate radiobuttonlist using JQuery, validate email address using JQuery and many articles relating to JQuery. Now I will explain how to validate dropdownlist using JQuery in asp.net.

jQuery Validate CheckBoxList in Asp.Net Example

Introduction: 

Here I will explain how to validate checkboxlist using JQuery using asp.net.

Description:
  
In previous articles I explained validate radiobuttonlist using JQuery, validate email address using JQuery, how to disable or enable all the controls on page using JQuery , validate phone number using JQuery and many articles relating to JQuery. Now I will explain how to validate checkboxlist using JQuery in asp.net.

JQuery Validate RadioButtonList in Asp.Net Example

Introduction: 

Here I will explain how to validate radiobuttonlist using JQuery using asp.net.

Description:
  
In previous articles I explained validate email address using JQuery, how to disable or enable all the controls on page using JQuery , validate phone number using JQuery and many articles relating to JQuery. Now I will explain how to validate radiobuttonlist using JQuery in asp.net.

JQuery Select Header Checkbox When All Child Checkboxes Selected in Asp.net Gridview

Introduction:

In this article I will explain how to check/uncheck or select/deselect all the checkboxes in gridview with header checkbox using JQuery in asp.net.

Description:

In previous article I explained select/deselect checkboxes in gridview using JQuery and how to select/deselect checkboxes in gridview using JavaScript and many articles relating to JavaScript and JQuery. Now I will explain how to select/deselect header checkbox when all child checkboxes selected in gridvuew using JQuery.

Check Uncheck All Checkboxes in Gridview Using JQuery

Introduction:

In this article I will explain how to check/uncheck or select/deselect all the checkboxes in gridview with header checkbox using JQuery in asp.net.

Description:

In previous article I explained how to select/deselect checkboxes in gridview using JavaScript and many articles relating to JavaScript. Now I will explain how to check/uncheck or select/deselect all the checkboxes in gridview with header checkbox in JQuery.