How to find duplicate records in a table of SQL server database using a SQL query?

We have a Customer table in sql server database with multiple fields and also data. Lots of data in this table and also multiple duplicates records of customers in this table. We want to find all duplicates records of customers and based on "CustCode" column. And also need to delete all duplicates records from Customer table. A customer should be...

Read More

What different between Var, Object and Dynamic data type in c#? How to use??

The data types (var, object and dynamic) are generally used while you are working with anonymous type. Var: This is a data type, var data type introduced since .Net Framework 3.0. Var datatype is pre-determined at compilation time. We cannot leave it unassigned or having a null value we need to implicitly assign a value to it otherwise we`ll receive...

Read More

How to find all image input in a container class and How to replace title string of each image (Replace '$' with '-') using Jquery?

We can find all image input inside a container class using Jquery .each() function and Replace/Update title string of using Jquery .replace() function. What is .each() Method in Jquery? This is Jquery library function. The Jquery  library provides a method, Each(), which will loop through each element of the target element (Object)....

Read More

What is a Tuple in C#? When it use? Example of Tuple

Tuple: Tuple is a generic static class that was added to C# 4.0 and it can hold any amount of elements, and they can be any type we want. So using tuple, we can return multiple values.One great use of tuple might be returning multiple values from a method. It provides an alternative to "ref" or "out" if you have a method that needs to return...

Read More

How To Convert HTML Table In To Div Tag

Using Jquery Convert HTML Table in to Div tag: Jquery function converting table in to div, see below jquery function: <script type="text/javascript">         $('table').replaceWith(function () {             var html = '';...

Read More