Posts Tagged ‘delete’

Delete duplicate rows from table without primary key in Sql Server

This is Friday and im writing this post to complete a previous one titled SqlServer-Delete Duplicate Records Rows In this post i will talk about how to delete duplicate rows using one of the built in sql server functions ROW_NUMBER(). And how to use it to delete Rows in a table without primary key. First: […]

More »

Delete Statment in SQL

DELETE (Transact-SQL) Removes rows from a table or view. in this post i will start series about deleting data from Table Or View. i will discuse and show simple and complex delete statments A. Using DELETE with no WHERE clause USE AdventureWorks2008R2; GO DELETE FROM Sales.SalesPersonQuotaHistory; GO B. Using DELETE on a set of rows […]

More »