In SQL Server 2008 Microsoft has introduced new feature called Table value parameters by using this concept we can directly pass table as parameter in stored. Sep 19, 2005. Try out the following example which demonstrates how to delete the duplicate records in Ms Sql Server. create table. May 31st, 2008. For example let us take emp table. query to delete duplicate row will be like this. Delete * from…