How to get Distinct Count across Multiple Tables in SQL Server

Hi Friends,in this article I will explain about  How to get Distinct Count across Multiple Tables in SQL Server.
I already explained in the previous articles about How to Remove/Delete duplicate records/Rows from a table in SQL Server,SQL Server 2008 : How to Remove Special Characters in a String , STUFF and PATINDEX Examples and How to alter primary key column for existing table in sql server 2008
Before knowing How to get Distinct Count across Multiple Tables first know about UNION ALL Operator.

jQuery:How to check all checkboxes except one checkbox || jQuery :not() Selector Example

Hi Friends,in this article i will explain about :How to check all checkboxes except one checkbox || jQuery :not() Selector Example.
I already explained in the previous artilces about How to change image opacity and Zoom on mouseover using jQuery, Jquery:How to add events in gridview using Jquery || Handling GridView event(RowCommand) and Binding and Sorting Grid in ASP.NET MVC using Jquery

How to fix System.Web.UI.ViewStateException: Invalid viewstate or System.Web.HttpException: The client disconnected exception or HttpResponse.IsClientConnected Property

Hi friends, in this article I will explain about  How to fix System.Web.UI.ViewStateException: Invalid viewstate or System.Web.HttpException: The client disconnected exception or HttpResponse.IsClientConnected Property.
I already explained in the previous articles about How to change image opacity and Zoom on mouseover using jQuery, How to alter primary key column for existing table in sql server 2008 and How to set column width If ListItem in a CheckBoxList have big length in ASP.NET using CSS

How to Remove/Delete duplicate records/Rows from a table in SQL Server

Hi friends, in this article i will explain about How to remove duplicate rows in SQL Server 2008.
I already explained in the previous articles about How to Remove Special Characters in a String , STUFF and PATINDEX Examples,How to alter primary key column for existing table in sql server 2008 and How to Get List of Stored Procedures based on table name search, using sql server 2008?  

SQL Server 2008 : How to Remove Special Characters in a String, STUFF and PATINDEX Examples

Hi friends, in this article I will explain about  How to Remove Special Characters in a String in SQL Server 2008   

I already explained in the previous articles about How to alter primary key column for existing table in sql server 2008, How to Get List of Stored Procedures based on table name search, using sql server 2008? and Differences and Similarities Between LEN and DATALENGTH Functions in SQL Server

How to change image opacity and Zoom on mouseover using jQuery

Hi friends,in this article i will explain about How to change image opacity and Zoom on mouseover using jQuery.
I already explained in the previous articles about How to add events in gridview using Jquery,Binding and Sorting Grid in ASP.NET MVC using Jquery and JQuery:Check Uncheck all CheckBoxes in ASP.Net CheckBoxList control