web analytics

Tagged: delete

Removing Duplicates through SQL Query 1

Removing Duplicates through SQL Query

Reading Time: 1 minuteSuppose we have a table in SQL Server, that has duplicates in it. CREATE TABLE T1 ( ProductName varchar(50) ) INSERT INTO T1 VALUES (‘Computer’), (‘Computer’), (‘Printer’), (‘Printer’), (‘Printer’), (‘Scanner’), (‘Scanner’), (‘Scanner’), (‘Scanner’), (‘Camera’),...

Different operations on Datatable (Add, Edit, delete, Sort etc) and XML 6

Different operations on Datatable (Add, Edit, delete, Sort etc) and XML

Reading Time: 5 minutesIntroduction DataTable is a central object in the ADO.NET library. If you are working with ADO.NET – accessing data from database, you can not escape from DataTable. Other objects that use DataTable are DataSet...